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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by elly00

  1. elly00

    SQL EXPRESSION

    Hi yessssssssssssssssssss thanks :)
  2. elly00

    create sql view using batch file

    Hi is it possibile to delete and tha generate a sql view using a .bat file? That because I don't want to give the full access of the db to the customer thanks Elena
  3. elly00

    SQL EXPRESSION

    SQL expression field..
  4. elly00

    SQL EXPRESSION

    Hi I need to set a SQL expression that in sql is like that select * from anagart where codiceart not in (select code from historycode) in order to have a list of codart that is not included in the historycode table.. How can i do that? When I try to specify that statment I receive an error...
  5. elly00

    sql result

    Hi,, how can I test the result of a query? For example I've SELECT COUNT(*)FROM TABLE.. I would like to store the result in a variable in order to test it
  6. elly00

    select with no record returned

    Hi I've done a select in a sql table..like (select myart from listarticle) The problem is that the select can return no records (if myarticle is not presenr in the table) In this case I receive a sql error So is there a way to check if the select doesn't return a recordset? Thanks
  7. elly00

    select error

    Hi I've a select like this: ObjAdoDbConnection_13.Open IstructionConnectionDatabase_13 ObjAdoDbRecordSet_13.Source = "SELECT * FROM MYTABLE WHERE CODART='"&CODART&"'" ObjAdoDbRecordSet_13.ActiveConnection = ObjAdoDbConnection_13 ObjAdoDbRecordSet_13.Open...
  8. elly00

    execute sql store prodecure

    Hi using vbs is it possible to run a sql store procedure? Have you an example of the command to use?? THANKS
  9. elly00

    subtraction using variables

    Hi I have two variables like a=1.22 b=1.55 operation is: c=a-b The problem is that the variable C dosn't have decimals..so the result when I write the variable is 0 and not 0.33 How can i format this operation in order to mantain the decimals? Thanks
  10. elly00

    preview xml invoice

    thanks!
  11. elly00

    printig sql tabel from vbs

    HI all, Is it possibile from vbs to print a sql table? I only need to send data to printer or have a little preview or export data in pdf file.... Usually I use crystal reports but I don't know if I can use something different.. Could you give me some ideas? thanks :)
  12. elly00

    preview xml invoice

    Hi having a xml file, is it possibile using vbs to have a preview of it? Or if is not possible to do directly call a external program to preview it? thanks
  13. elly00

    read PDF content

    Hi, thanks for your help I have a vbs code that parse a txt doc.. Now my problem is to save/transform pdf to a txt file.... Do you know if there are something free to use in vbs? THANKS
  14. elly00

    read PDF content

    Hi is it possibile using vbs to search a specific text on a pdf document? Thanks
  15. elly00

    error opening email

    Hi.. I check the command..it's correct CreateObject The strange thing is that we have the errore only in some pc ..in other all works as usual..

Part and Inventory Search

Back
Top