Subject Re: [firebird-support] Beginner questions: from access to firebird (using vb and odbc driver)
Author Jason Dodson
> questions:
> 1) can i leave the database connection open through all the program
> process and close at the end of my program ?

Of course.

> 2) the recordset: i've to define them as i use to do with access ?
> Public rsTable As ADODB.Recordset

Just like ANY other variable... depending on the scope needed, it may be immediately local, module global, or
application global.

> 3) I need to open recordset ?
> rsTable.Open "SELECT Utenti.* FROM Utenti WHERE Utenti.Utente = '" +
> UtenteSel + "'"

The params afterward are important. See

> 4) The above query how can translate into fb syntax ?

It already is.

> 5) how i can retreive the value for example of a field (field_text)
> contained in a table (table_demo) ?
> in vb - access i use:
> Dim test as string
> test = rsTable_demo("field_text")

Same way. Did you not even TRY looking this up first?


The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.