search

gozoinks / keystonefilemakerplugin

Automatically exported from code.google.com/p/keystonefilemakerplugin
0 stars 0 forks source link

CREATE & DROP TABLES HANGS FILEMAKER #1

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
As far as I know, the only major bug is that trying to use CREATE or DROP TABLE 
as part of your SQL 
will hang FileMaker. SELECT, WHERE, INSERT etc etc all work fine. Can someone 
help me debug?

Original issue reported on code.google.com by ChrisKubica on 15 Sep 2009 at 3:08

GoogleCodeExporter commented 9 years ago 
It appears that FileMaker is waiting to get a lock on the File, which it can't 
do because there is a calculation in 
progress (the plugin call.)

Force quitting FileMaker seems to drop the table (if using drop)

Not sure of the cure yet, but this may help.

Original comment by canterbu...@gmail.com on 16 Sep 2009 at 8:46

GoogleCodeExporter commented 9 years ago 
needs to execute on idle

Original comment by ernest...@gmail.com on 10 Oct 2009 at 1:26

GoogleCodeExporter commented 9 years ago 
Indeed. You will need an extra optional parameter to indicate it should execute 
on Idle.
+ Some way to store the query so it can be picked up by the idle handler.

Original comment by clari...@gmail.com on 24 Mar 2010 at 12:54