Has anyone come across this problem before - I could really use some help please!
I am testing a VB
application for Windows Xp compatibility, which works under its previous NT environment.
The problem I have occurs when the program attempts to write some information to the loraDockets dynaset (see the relevant SQL string). There is no problem if the data type of the loraDocket is Int/Date - the only issue is where the data is of type "string". If this is the case, then the data written is corrupt (usually "?"s and some other random control characters!).
The (what I think are) relevant parts of the code are as follows:
Dim loraDockets As Object
Public odoSesCLT As Object
Public odoDbCLT As Object
Set odoSesCLT = CreateObject("OracleInProcServer.XORASession")
Set odoDbCLT = odoSesCLT.OpenDatabase(SQLNetName, Username & "/" & Password, 1)
Set loraDockets = odoDbCLT.CreateDynaset("select * from clt_client_docket where status_ind = 'S'", 0)
'The problem occurs here: (after we have found the relevant docket to
'process - ie, loraDockets.moveFirst / other code has been executed)
loraDockets("brand_code") = "TEST"
'Here brand_code is a field on the Oracle table, of type String, size4.
I hope you can help,