i was assigned to modified existing vb.net programm. but i face a problems~ where is:-
vb.net 2003 with SQL2005 Express
when application started with good network connection, then i removed the network cable, the system throw error message "The connection is dead".
however, if the application...
i dont know whether my message is in in correct forum.. sorry if i wrong.
i having a very funny situation. please guide me if you got this experience.
My receipt printer has binded an image. therefore everytime my application print document to receipt printer, the printer will print out the...
i'm using datagrid view to display some records that query from database.
[Product Name], [Qty On Hand]
the column [Qty On Hand] is a numeric column. in the grid i allow user to imediate change any numeric value as they wish. but if use key in character, the system return error. i was trying...
i'm am vb6 programmer, is a beginner of vb2008. i faced some difficulties that not exists in vb6. please help:-
i have 2 forms: Form A and Form B
Form A call Form B. in Form B, once i close Form B, i will need to pass some data from form B back to Form A without refresh my Form A.
in vb6, i...
There is a Delphi Program is accessing dbf tables through BDE (Borland Database Engine). meanwhile, my VB program also wanna access some dbf tables. but vb return me error message as "The Microsoft Jet database engine could not find the object....". If i just execute my vb application and query...
thanks "falconsight"
how about if i want delete the all VFP data and pack the database? is that any ways to do in VB6? i would like to have a clean database instead!
thanks for help!
with the connection string below, i write the queries
Provider=VFPOLEDB.1;Data Source=C:\VFPDATA;Collating Sequence=MACHINE;Mode=ReadWrite
-------------------------------------------------------
SQL = "DELETE FROM FoxPro_Employee.dbf"
gconn.execute SQL
cmd.CommandText = "Set Exclusive On:pack...
the temp table is created at previous functions.
the whole process of my module is an exe will taking out the respective DBFs files from a zip file. based on the DBFs, it will create temp tables in SQL server. from the temp table then only insert into sql tables.
after few times i'm checking...
Above is my Stored Procedure inside my SQL server.
i have tried at other machine. the stored procedure is running successfully and also the data from DBF has inserted into SQL server.
can any "anonymous" files make my process failed?
thanks alot for giving me some guides.
regards,
nicholas
/*
<VERSION> 1.0.0.7 </VERSION>
ADDED: Fixed to return set @@ERROR to @ERROR_CD to return actual error
<VERSION> 1.0.0.6 </VERSION>
ADDED: TO ENABLE THIS IMPORTSALES2 TO BE ABLE IMPORT IN THE SALES FOR DIFFERENT POS NO (ONE OUTLET THAT HAVING MANY POS)
THE THING AFFECTED IS THE AVERAGE COST...
I use stored Procedure to do import data from DBF database(source files)into SQL server database. the process of the stored procedure is run successfully, but data is not insert into SQL server. sometimes it it is import succesfully into SQL server with the same DBF database(source files).
my...
i'm using the CRViewer to view my report. i found out i cannot pass in Date into crystal report from VB. any one can give me help?
sample code:
CrxReport.ParameterFields(1).AddCurrentValue (format(now,"dd/mm/yyyy"))
the parameter in crystal report defined as Date.
thanks.
SQL------------------------------------------------
SELECT T1.RCP_NO, T2.DSCCODE, T2.DSCVALUE, T1.BN_DT
FROM DETAIL T1 LEFT JOIN DISCOUNT T2 ON T1.PROD_CD = T2.DSCCODE
WHERE (cdate(T1.BN_DT) >= '01/Sep/2007' AND cdate(T1.BN_DT) <= '15/Sep/2007')...
language:vb6
database: ms access
i would like to list out all the tables name that are exits in my databse. i know got a way is to check the table whether is exist. is yes, return true. if not, return false.
beside this way, is that any other way?
i woulid like to display the tables name that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.