I have been using an ADODB RecordSet object to connect to my server over the internet. oRs:Open( cUrl ). Actually very fast, works well. What I don't know, or can't figure out is if I can use this on a secure site. Can't seem to get it to work. It works if I use Hamachi (VPN), but not ...
oDbf:OrdKeyCount() ) This works only for oDbf. Using oBrw:nLen or oBrw:KeyCount() works for all datasources. ok but the button are not refreshed , only when I move the mouse into obrw for a sample WHEN ( oBrw:nDataRows <= oBrw:nLen ...
... oRsDet oRsWrk and oRsDet are RecordSets. You should not use recordsets. Use table names. if the table names are "original" and "work", then the sql is SELECT * INTO [WORK] FROM [ORIGINAL]
When these attributes are used, it doesn't work. I have done tests without them, then it works. There are so many ifs in the class that it would seem better to me to make a new one without all this legacy. Best regards, Otto
... Work\FWH\lib\Fiveh.lib=40C:\Work\FWH\lib\Fivehc.lib=41 but also want uuid.lib But I saw on bcc7.30 there are two uuid.lib one on C:\Work_old\bcc7\lib ...
Please try this for adding new record. This is working for me and should work for you too. First run this program as it is without changes before you adopt to your tables. function MariaNewRecord() local oCn := maria_Connect( "209.250.245.152,fwh,fwhuser,FiveTech@2022" ...
... aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow } )endif But insert not work. Table `states` has 3 fields: id, code, name where id is autoincrement field This should work: oCn:Upsert( "states", nil, { ...
Please try this for adding new record. This is working for me and should work for you too. First run this program as it is without changes before you adopt to your tables. function MariaNewRecord() local oCn := maria_Connect( ...
... == NIL // not found, then inserts aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow } ) endif But insert not work. Table `states` has 3 fields: id, code, name where id is autoincrement field This should work: oCn:Upsert( "states", nil, { ...
... { "WA", "Washington" }// Edit the array and thenoCn:Upsert( "states", nil, { aRow } ) Mr Rao, this works when there exists any record from select. When the select there no result, insert does not work. I am try this: aRow := oCn:QueryResult( "select ...