Valentina SQL examples

[Kavitha]

Hi,

On 2007-09-21, at 19:33, Kavitha wrote:

> No, I read the SQL reference.
> My question is how to apply this in revolution?
>
> for example how to create table in revolution using SQL reference?
>
> Pls let me know if I am still not clear

although I'm a complete Rev newbie ...

* Install the actual Valentina PlugIn (if you didn't do it, the  
delivered on from Rev is very matured)

* Open the V4Rev Examples stack

* there is a SQL_way_Table_CreateDrop SubStack  - I got till here

* using the browser to access the scripts in there you'll find

i.e.

   set the cursor to watch  - how to set the cursor

   put "CREATE TABLE Person ( firstname string(40)  )" into query
   get VDatabase_SqlExecute( mDBRef, query )

Thank you very much,  I could see some of the code but not sure how to see the code on the stack that has create table and drop table button.  I am relly very new to this, as you can see from my questions. Thank you so much for helping.

Kavitha