Recent content by lupien1

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...