jet
Help with this JET Sql Query
I need help to do this query select. for example I have these fields: idInvoice date amount Depending of the date I need multiply the field \"amount\" for x number or other one.[详细]
2023-01-04 00:37 分类:问答Read binary data from a MDB-file running under LAMP
I need to be able to connect to an MDB-file in a LAMP-environment (running on Linux) and ultimately insert converted data into a Mysql db.[详细]
2023-01-02 04:00 分类:问答How to determine Jet database Engine Type programmatically
I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn\'t already that version. (This enables use of SQL-92 syntax features)[详细]
2022-12-31 05:15 分类:问答Get id when inserting new row using TableAdapter.Update on a file based database
I have a database table with one field, called ID, being an auto increment integer. Using a TableAdapter I can read and modify existing rows as well as create new ones.[详细]
2022-12-29 21:22 分类:问答What does Error 3112 indicate when compacting an MDB file?
What does Error 3112 indicate when compacting an MDB file? The Error description is \"Records can\'t b开发者_开发百科e read; no read permission on \'xyz123.mdb\'\"[详细]
2022-12-29 19:44 分类:问答JET SQL: do LEFT JOINS and RIGHT JOINS only work under JET 4.0 and above?
Does the following article apply to all uses of JET (including from within client ap开发者_C百科ps via DAO or OLEDB):[详细]
2022-12-28 15:34 分类:问答OleDB Jet - Float issues in reading excel data
When I read a sheet into a DataTable using the OleDbDataReader, floating point numbers loose their precision.[详细]
2022-12-26 04:15 分类:问答using ResultSet.Previous method not working in Java using .mdb file OBDC
I\'m currently having an issue with my open result set not working how I believe it should. The only function that is currently working is the next() method, nothing else will work. If the project is[详细]
2022-12-25 18:39 分类:问答How can I store large character values in MS Access?
I\'m using an MS Access database. I want to store a description field having more than 255 characters. Wh开发者_运维问答at do I need to do?Use a Memo field instead[详细]
2022-12-25 18:27 分类:问答Accessing a JET (.mdb) database in Python
Is there a way to access a JET database from Python? I\'m on Linux. All I found was a .mdb viewe开发者_开发百科r in the repositories, but it\'s very faulty. ThanksMDB Tools is a set of open source lib[详细]
2022-12-25 14:22 分类:问答