Recent

« previous next »
Pages: [1]

Author Topic: I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta  (Read 4481 times)

Mando

  • Full Member
  • ***
  • Posts: 181
I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta
« on: November 13, 2012, 06:10:16 pm »
Hello:
 
 That's my problem:
 
 I'm developing an aplication than generates a table according some values wich determine how much columns table should have.
 
 The first time I lanuch the process it works properly, but second time, I must drop that table. I close de component (TZQuery) first, but I get this error :
 (see attachment)
 
 
 I'm currently using Lazarus 1.1, FPC 2.6.6.
 Before installing 7.1-beta , I was installed 6.6.6 with a patch and my application worked fine.
 
Is there any solution?
 
 regards 
« Last Edit: November 13, 2012, 06:31:35 pm by Mando »
Logged

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta
« Reply #1 on: November 14, 2012, 09:24:44 am »
Perhaps posting this on the Zeos forum will get you more responses?

Regardless, showing the code that does the drop and the database involved may be a good idea.
A bit of an obvious question but are you sure the table is there the 2nd time you do the DROP?
Logged
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

EgonHugeist

  • Jr. Member
  • **
  • Posts: 78
Re: I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta
« Reply #2 on: November 16, 2012, 09:12:06 pm »
Logged

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta
« Reply #3 on: November 17, 2012, 03:51:41 pm »
Thanks for taking the time to mention that in this thread, Michael!

PS: sqldb has prepare/unprepare for the queries (I assume their behaviour is similar to zeos' but TBH don't know - people like ludob would though)

« Last Edit: November 17, 2012, 03:56:32 pm by BigChimp »
Logged
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

EgonHugeist

  • Jr. Member
  • **
  • Posts: 78
Re: I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta
« Reply #4 on: November 18, 2012, 03:43:30 pm »
Quote
PS: sqldb has prepare/unprepare for the queries (I assume their behaviour is similar to zeos' but TBH don't know - people like ludob would though)

Yes and no, BigChimp. Some things can be done virtually like Zeos did it for SQLite until today (CAPI implemented R2012). Had a look... ((: We have some supports mor on our side.

I'm in contact with LudoB. He also helped use on a lot of plattform (AMR f.e.) issues. A nice coder, really.

Regards, Michael
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018