Search results for query: *

When using « printf("%e", value) » the output use 3 digit for the exponent part (ex. 3.5e+004). How can i get a result with only 2 digit in the exponent part (ex. 3.5e+04) Thank you

Do you have a Data Source Name (DSN) created for the database you want to import?

We need to retreive the NOT NULL column configuration on a table MSaccess database. We use the SQLDescribeCol function and the last parameter that is supposed to tell us if a column allow NOT NULL value without success. It always returning the same result. Is there a known problem between...

Is someone can tell me if there is a setting in VB to force the result after the compilation (exe or dll) to be copy automatically in a specific directory (other than the source one). In Visual C we can do it in a postbuild option setting. Thank you

You could try this: select count(*) from mydb where (myfield/10000) >= 1 hope this help

To add a password on an Access database, i can open msaccess, use the "Set Database Password" option in the Tools->Security menu and it work perfectly. I'm programming in C and i would like to know if i can assign a database password using ODBC and an API function like SLQConfigDataSource. Any...

I test a function (C language) that get the system configuration (decimal symbole) to show decimal value with comma or point. I did not have time to implement it and i don't remember the name of that function. Is there someone who know the name of this function? Thank you.

Why don't you use the "Data Source ODBC administrator" tool. 1- create DSN (datasource name) for your MDB file 2- create a shortcut on the desktop for the "Data Source ODBC Administrator" Your client will only have to: 1- Launch the "Data Source ODBC Administrator" with the shortcut on the...

Thank you Lilliabeth, But we are not using access Forms and a value can be insert from other product like msquery, SQL*Forms or SQL*Plus. So, the mask must be use for my case.

Hi Remou, There is a problem about the > as a format. The data is store in lowercase, but we see it in uppercase in the access field. If i gain the focus in the access field, the data is converted in lowercase as it is store. If i query this field with another product (SQL*Plus) the result is...

Thank you Remou, I tried your suggestion and it work, but we need to quit the field to see the effect. That's OK but i keep asking the question about the Inputmask to see the effect as we type.

When defining a field with an inpumask to uppercase the data entry, do we have to always repeat the letter length time following the > to force all letter to be capitalize. There must be a simple mask to do the same job. ex. to uppercase every letter from a 10 characters text field i do...

There is something i don't understand. When Datetime type is treat by SQLDescribeCol, the Colsize return is 23 "YYYY-MM-DD HH:MM:SS.000". Why Datetime is correct but not smalldatetime? I can't use your SELECT suggestion because our function build a structure dynamically with all table retreive...

To dynamically set the length of a variable (Code in C) to store data, i use the ODBC API function SQLDescribeCol. When a smalldatetime column type from SQLServer is treat by SQLDescribeCol, the COLSIZE return by the function is 16 when YYYY-MM-DD HH:MM:SS contain 19 characters. This case...

I try the "Microsoft Jet 4.0 OLE DB Provider" (suggestion from another forum) and it work. The only thing, is the result of this simple query "select * from db_access...table1" return the column in alphabatical order instead of the creating order. Using the same db link with openquery return...

In SQL Server Enterprise Manager, the provider i use to create my db link for my access database is: Microsoft OLE DB Provider for ODBC Drivers Thank you

I need to insert the data include in table1 from database1 in the table1 of database2. table1 in both database are identical and have 35 columns and the 2 first column are primary key. Can someone can tell me the query to do the job. The query must validate value to avoid primary key...

With MS access what is the database name and the owner name?

Hi, The following query on a link db server is working select * from OPENQUERY(db_access, 'select * from tab1') if i tried the following query with part-name instead of OPENQUERY, i have an error message select * from db_access...tab1 error message #7313 (problem with MSDASQL) What...

To get more complicated suppose that tab2 have the same name has tab1 and is comming from another database, what will be the WHERE clause. insert into tab1 select * from openquery(db_access, 'select * from tab1')...