best code for

[damianodec]

hi,
I need a suggestion, what's the best solution for interactive ADODB I/O app ?
I'd like a app that by dialog manages data of SQL server:

Code: Select all

...
// connection
oCn := FW_OpenAdoConnection( ConnectString, .t.)

...
// HERE DIALOG...

cExecute := "INSERT INTO TABLE (CODE, DESC) VALUES (cCode, cDescr)"
    try
        oCn:Execute( cExecute)
        msginfo("insert ok")
    Catch
        msginfo("insert error")
    End Try 
...
 

is this (oCn:Execute) a good way ?
are there others ways for manage I/O data by ADO connection?

thanks

[Enrico Maria Giordano]

Yes, INSERT INTO is the best option.

EMG

[damianodec]

hi Enrico, thank you,
what I'd like to know is if oCn:Execute is the best solution or are there other better FW_ function ?

thank you

[Enrico Maria Giordano]

Probably. But I prefer to not hide something (ADO) that already hides something else.

EMG

[nageswaragunupudi]

oCn:Execute is the best solution or are there other better FW_ function ?

oCn:Execute( cSql ) is the most suitable method to use here.

[damianodec]

thank you!