On Friday 06 March 2009 04:25:04 pm Uwe Grauer wrote: > johnf wrote: > > When using statements like > > "select somefield in dataset " > > SQLite might error on an unsupported datatype of the database you are > > using. > > I was under the impression that the selects on datesets work like > a select from a table. But the above doesn't look like valid sql. > I never used the "select on dataset" feature. I'm just asking out of > curiosity. > > Can you bring some light into this? > > Uwe That should have been "from" as in "select somefield from dataset"
It is a way to select data from a current dataset by using the bizobj cursor. I just wanted others to be aware that no error was appearing and the form continued to run. The only reason I discovered the issue was I had a grid that displayed a virtual field that used the dataset select statement. I couldn't determine what was wrong until by accident I had to run the form on windows. Then and only then did I see any sort of error message and only after stepping into the code. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
