JayT
Posts: 14
|
| Posted: 08/08/2006, 2:38 AM |
|
Can anyone help?!!
Using code charge studio to build reports. Code charge is connected to a MS Access 2003 database.
everytime i try an produce a report in code charge studio using query tables developed in MS Access get an error;
"Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3., SQL state 07001 in SQLExecDirect in c:\program files\easyphp1-8\www\newproject2\db_odbc.php on line 88"
can any one shed some light on this.
Within the query there are only two parameters stated.
any help will be usefull, thanks
|
 |
 |
Phil
|
| Posted: 08/10/2006, 1:29 AM |
|
Simple, make sure your database is done well, and the connection works properly. Then use the report builder to build a report with a search if you wish. That should allow you to search your records, and do some basic analysis e.g. total number of records either in a group or as a whole (the search criteria). Along the steps, it will ask if you want to have a printable version, simply chose yes, select the number of records you wish to display on a page and finish.
If you did all the above and nothing is working, maybe you need to refine your search terms or go through your database slowly to see whats not right. I have never experienced that problem as it always worked perfect for me. I am working with a MS access 2003 database and it works like magic.
|
|
|
|
|
