FiveTech Software tech support forums

Posted: **Tue Dec 17, 2019 8:39 pm**

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

Posted: **Tue Dec 17, 2019 10:41 pm**

Yes, INSERT INTO is the best option.

EMG

Posted: **Wed Dec 18, 2019 7:19 am**

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

Posted: **Wed Dec 18, 2019 9:13 am**

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

EMG

Posted: **Wed Dec 18, 2019 7:07 pm**

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

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

Posted: **Thu Dec 19, 2019 7:45 am**

thank you!

FiveTech Software tech support forums

best code for

best code for

Re: best code for

Re: best code for

Re: best code for

Re: best code for

Re: best code for