Search results for query: *

Hi yessssssssssssssssssss thanks :)

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

SQL expression field..

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

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

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

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

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

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

thanks!

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 :)

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

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

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

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

Hi from a vbs file we open an outlook email using set out=createobject("outlook.application") set namespace=out.getnamespace("mapi") mail.Display 'visualizzo la mail Starting from today (yesterday all worked correctly) we receive this error (outlook 365) Error: the class...

Hi, I've a field ALQIVA decimal(8,5) If I try to test the content I receive an error of type mismatch the filed cin db sql is 22.00000 The code is; If ALQIVA=22.00 then CODIVA=23 End If

Hi I have a xml file that I read to save data in db table The section of sql that gives problem is like that: <AltriDatiGestionali> <TipoDato>Cod: 1</TipoDato> <RiferimentoTesto>GAS</RiferimentoTesto> </AltriDatiGestionali> -<AltriDatiGestionali> <TipoDato>Cod: 1</TipoDato>...

Ho No i don’t have a folder in my zip dile. Simply the cde extract the files in the same directory but in a new folder named with the same ñame of zip file

yes sorry c:\test was only an example I need to extract files in c:\FILEXML the same direcotry if zip file