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

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
    982 Posts
    ACCEPTED ANSWER

    Re: Database problem?

    ‏2011-07-05T12:10:50Z  in response to Cagri
    Hi,

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

    Regards

    Alex
  • academician1
    academician1
    6 Posts
    ACCEPTED ANSWER

    Re: Database problem?

    ‏2011-07-05T15:59:07Z  in response to Cagri
    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
      ACCEPTED ANSWER

      Re: Database problem?

      ‏2011-07-22T15:28:08Z  in response to academician1
      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.