Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nicholasting

    The Connection is dead?vb.net2003 vs sql2005express

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

    Visual Basic.net VS MS SQL VS Receipt Printer

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

    vb2008 datagridView cell validating

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

    Help: receive some data from other form

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

    BDE Crash my VB's DBF Query

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

    VB6: delete data and pack Visual FoxPro Database

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

    VB6: delete data and pack Visual FoxPro Database

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

    Stored Procedure: SQL & DBF

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

    Stored Procedure: SQL & DBF

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

    Stored Procedure: SQL & DBF

    /* <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...
  11. nicholasting

    Stored Procedure: SQL &amp; DBF

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

    Passing parameter to Crystal Report

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

    Query between VB and Dbase IV

    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')...
  14. nicholasting

    List Out The Tables Name Exists In Database!!!

    connection Method: microsoft activex data objecs 2.6 library connection: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\User\Desktop\Casa Vino Database\Coding Database.mdb;Mode=Read;Persist Security Info=False;jet oledb:database password=88888 SQL: SELECT Name, Type...
  15. nicholasting

    List Out The Tables Name Exists In Database!!!

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

Part and Inventory Search

Back
Top