Originally posted by: SystemAdmin

[glitter said:]

Hi,

Do you know how can i determine decimal places of my output while inserting it in to a table in the database?
I tried the following code, but it gives error.
DBExecute(db, "create table XBooks(BookID int, NbofBooks float(2)");
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[vblanchard said:]

Hi,

What type of database are your working with (Oracle, DB2, MS SQL Server, etc.)?
To be able to help you, it would help if you could insert the code that actually writes to the database and the error message you get.


#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[glitter said:]

i am working with  Microsaoft Access.
And the code gives error as syntax error for the following line:
DBExecute(db, "create table XBooks(BookID int, NbofBooks float(2)");


#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[vblanchard said:]

The "Create" statement you're using is not accepted by MS Access (you can test your query directly with Access).
If you create the table without specifying the decimal place as below it works:
DBExecute (db,"create table XBooks(BookID int, NbofBooks float)");


#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[glitter said:]

ok, do you know how to limit decimal places in a create statement?
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[vblanchard said:]

Unfortunately I don't know the syntax that MS Access would accept. Some forums dedicated on SQL for MS Access may be able to help you.
Once you have an SQL statement that is valid for MS Access, it should work within OPL.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[glitter said:]

ok, thanx
#DecisionOptimization
#OPLusingCPLEXOptimizer