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

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

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.

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

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

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

Here is two Table: tab1 tab2 col1 col2 ... col1 col2 ... 1 A 1 C 1 B 1 D 1 C 1 E In tab1 col1 and col2 are primary key. I would like to...

With Oracle i use: COPY FROM USER/PW@ODBC:ACCESS_DB INSERT TAB1 USING SELECT * FROM TAB1; to copy the data content of the table tab1 from access to oracle tab1. What can i do to have the same result with Sqlserver. Thank you!

I'm looking for a SQL function for SQLServer that work has Oracle function DECODE(TOTO, NULL, "OK") or Access function IIf(TOTO Is Null,Null,' /' & TOTO).

Is there another way to import in sqlserver an "Access queries" than having to cut and paste the SQL code. Thank you!

I'm having a problem with the "Windows CD writing wizard". When using this wizard, the process start writing, the progress bar show us that it is working but with 5 second to go, the process freeze. The LED on the burner unit is off during all the process (no writing). This problem happen since...

Hi, A lot of our program are develop in C. Can someone tell me how to interface a call made from C language to a function in a DLL made in C++. An example or a WEB link will be appreciate. thank you.

Hi, With MS-DOS command prompt under Windows XP, when i try to launch simple application like "edit" the prompt freeze and i have to kill the process with the task manager. It seem that every console application launch under the MS-DOS prompt freeze. Can someone help me!

Hi, I would like to put dynamicaly, has information in my about dialog box, the date and the time when the link of the program has been done. How can i do this??? Thank you

I have a dos batch (.bat) file working fine and doing these tasks: 1- preparing files 2- launch a console program (DOS program) 3- copying result files I use scheduled tasks to launch the batch file each 10 minutes. The automatic launch is worwing fine, but i would like the DOS shell windows...

All variable, in the following "for loop exemple" except nbval are double type. I have a problem with the condition "val <= valmax". When val is increment by the step value and equal to valmax the for loop break has if the val was greater than valmax. How can i correct this problem? for...