new bug FW 13.05:can´t append records to ACCESS and TDatarow

[nageswaragunupudi]

I executed your exe as it is on empty table.
I did not get any runtime error.
This is the result.


Surprising that you have problems on different PCs

Wondering how to find what is that difference that is creating the problem.

[lucasdebeltran]

Mr. Nages,

Thank you very much for your help and patiente.

It is very strange.

Which OS do you use?.

And which ODBC Access driver are you using please?.

Thank you.


PD. Antonio, can you also test my .exe and EMPTY ACCESS.MDB please?.

[nageswaragunupudi]

Windows 8 32 bit
I have both ACE 12.0 and Jet Oledb.
FW_AdoOpenConnection( <mdbfilename> ) defaults to ACE in my case.
I also tried opening with JET ( using jet connection string) and tried and then also it works.

Actually, not only for this example, I am also doing work with access in other applications also for me all my applications are working.

Yes we can ask Mr Antonio also to try.

Please let me know if you are using FWH13.05? or mix of 13.04 and the new programs?

[lucasdebeltran]

Can you please test on Windows 7 or XP?.

>>I have both ACE 12.0 and Jet Oledb.
>>FW_AdoOpenConnection( <mdbfilename> ) defaults to ACE in my case.

How do you achive it?.

Which connection string do you use for ACE 12 please?.

Can you please sent to my email fixed FW 13.05 libs please?.

Thank you.

[anserkk]

I tested your exe on my PC (Windows 7, 32 bit).

It is working fine

Regards
Anser

[nageswaragunupudi]

Mr Anser

Thank you very much for testing.
Can you also please test on XP, in case you have an XP around ?

[nageswaragunupudi]

Mr Lucas

Please try this
After opening RecordSet

oRec := TDataRow():New( oRs, , .t. )
oRec:aData[ 1, 3 ] := .f. // means readonly

Assign values to some fields but not to the field ID
and then call

oRs:Save()

Please let me know if this works for adding first record to a new empty table ( having ID as the first autonumber column )

[anserkk]

Mr Anser

Can you also please test on XP, in case you have an XP around ?

Dear Mr.Rao,

Tested on Windows XP (Service Pack 3) and it is working fine.

Regards
Anser