Topic
  • 3 replies
  • Latest Post - ‏2011-07-22T15:28:08Z by SystemAdmin
Cagri
Cagri
13 Posts

Pinned topic Database problem?

‏2011-07-04T09:00:41Z |
Hello,

I have a decision variable

dvar int+ rProducts,Dealers, Collection_Sites, Periods;

and I have commands

(i)in the mod file:

tuple rresult {
string Products;
string Dealers;
string Collection_Sites;
int Periods;
int r;
};

{rresult} rResult={<a,b,c,d,r[a][b][c][d]>|a in Products, b in Dealers, c in Collection_Sites, d in Periods};
(ii)in the dat file:

Dat file

DBExecute(db,"drop table rResult");
DBExecute(db,"create table rResult(Products varchar,Dealers varchar, Collection_Sites varchar, Periods real, rValue real)");
rResult to DBUpdate(db,"INSERT INTO rResult(Products,Dealers,Collection_Sites, Periods, rValue) VALUES(?,?,?,?,?)");

But I confronted with an error as below;

Description Resource Path Location Type
Database error (state=22001 code=31): MicrosoftODBC Microsoft Access SürücüsüDize verisi saðdan kesilmiþ , near "rResult"
Do you know what this problem is about?
Updated on 2011-07-22T15:28:08Z at 2011-07-22T15:28:08Z by SystemAdmin
  • AlexFleischer
    AlexFleischer
    2075 Posts

    Re: Database problem?

    ‏2011-07-05T12:10:50Z  
    Hi,

    can you attach your project so that other people could try to reproduce or help?

    Regards

    Alex
  • academician1
    academician1
    6 Posts

    Re: Database problem?

    ‏2011-07-05T15:59:07Z  
    I have to say that The same program works in an another computer. The results were written to the database.
    On the other side another model (inclluding tuples) works in the computer that the other model results in an error message. It is very strange.
  • SystemAdmin
    SystemAdmin
    1883 Posts

    Re: Database problem?

    ‏2011-07-22T15:28:08Z  
    I have to say that The same program works in an another computer. The results were written to the database.
    On the other side another model (inclluding tuples) works in the computer that the other model results in an error message. It is very strange.
    Are you working on Windows 64-bit?
    There is currently an issue updating data in Microsoft Access when working with the 64-bit ODBC driver.