I can't use "DROP TABLE" - Lazaruz - ZEOS 7.1- beta
lazarus / 16-Databases

----------------------------------------------------------------------
Mando · 2012-11-13 17:10

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

----------------------------------------------------------------------
BigChimp · 2012-11-14 08:24

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?

----------------------------------------------------------------------
EgonHugeist · 2012-11-16 20:12

Case closed...

http://zeos.firmos.at/viewtopic.php?p=16568#16568

----------------------------------------------------------------------
BigChimp · 2012-11-17 14:51

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)

----------------------------------------------------------------------
EgonHugeist · 2012-11-18 14:43

QuotePS: 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