Search results for query: *

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

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

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 is it possibile using vbs to search a specific text on a pdf document? Thanks

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

hi I have a folder with a zip file like this: c:\test\aaa.zip using the code below I can extract the files but in the same folder .."c:\test\aaa\*.files" How can I modofy the code in oreder to extract the file in my orignal directory "C:\test" and not in C:\test\aaa\? Set fso =...

Hi, I've a numerica variable like this a=30.00 I'm doing a sql inser in a field decimal (8,5) using the command insert into..values The problem is that i should insert that variable as 30,00 leaving the dot as separator SQL doesn't accept value What can I do? THANKS

Hi, using vbs I need to read the various sections present in a file named (dettaglio linee). The file is like that: <DettaglioLinee> <NumeroLinea>1</NumeroLinea> <CodiceArticolo> <CodiceTipo>SA</CodiceTipo> <CodiceValore>a1ss</CodiceValore>...

hi we are using vbs reading from a sql table As yo know the decimal separator for sql server is "." Now trying to run a round command it doesn't work because it's waiting for "," as separator..is that possible? So If I run round(76.25) it doesn't work If I run round (76,25) it works correctly..

Hi I would like to ask you if it's possible using vbs to split a pdf document For example if my pdf have 3 pages I would like to have in a specif folder 1.pdf 2.pdf 3.pdf basically one page should generate a document thanks!!!!

hi I have a program that write a qta in a txt file The data is written like 5010, 10000 and I would like to have it like 50,10 -- 100,00 How can I format the number with 2 decimals? thanks

Hi I'm using Crystal Reports to print some code 128 labels All it's ok..My problem is that some codes that I need to print have a "/" on it.. and when I read the barcod the "/" become a "-" Have you ever had this problem? thanks