|Subject||Re: [firebird-support] Beginner questions: from access to firebird (using vb and odbc driver)|
> questions:Of course.
> 1) can i leave the database connection open through all the program
> process and close at the end of my program ?
> 2) the recordset: i've to define them as i use to do with access ?Just like ANY other variable... depending on the scope needed, it may be immediately local, module global, or
> Public rsTable As ADODB.Recordset
> 3) I need to open recordset ?The params afterward are important. See http://www.w3schools.com/ado/met_rs_open.asp
> rsTable.Open "SELECT Utenti.* FROM Utenti WHERE Utenti.Utente = '" +
> UtenteSel + "'"
> 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)Same way. Did you not even TRY looking this up first?
> contained in a table (table_demo) ?
> in vb - access i use:
> Dim test as string
> test = rsTable_demo("field_text")
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.