Can I write sql to query a topspeed table? 1

[rleiman]

Hi Everyone,

I use SQL very much because I come from an Oracle background.

Can you tell me what I need to do so I can write sql code to fill a listbox? Also can I write sql code to populate an entry or string field? If so, what are the steps?

Thanks.

Emad-ud-deen Richard Leiman

 

[ShankarJ]

Hi Emad,

Read the manual/help files on SQL accelerator drivers. It explains everything.

The way you do it is by defining a DummyTable and doing a PROP:SQL on it.

Regards

 

[rleiman]

Hi ShankarJ,

Thanks for the reply.

So does that mean I can only use it on Oracle or a table through odbc and not a topspeed table?

If I can do it on a topspeed table, has a tutorial been posted?

Thanks.

Emad

 

[ShankarJ]

Hi Emad,

To try it with TPS files using the ODBC file driver, you need the TopSpeed ODBC driver which at best manages to do the simple queries without errors. Also, it is not suggested to do a PROP:SQL against TPS files as it may not work properly. Check out

http://www.icetips.com/downloads.php

and download the Better SQL and OOP and read that. It is very informative. You also have a cwODBC class that you can use for PROP:SQL queries.

Regards

 

[rleiman]

Hi shankarJ,

Thank you for the link.

The main reason I was thinking about using SQL was because of the other problem I was having doing the totals on my browse listbox. Usually in I would do a sum(column_name) to get those totals if I was doing it in PL/SQL with the Oracle tools.

Truly,

Emad