Search results for query: *

Dear All, I opened a delimited file using Basic Driver which contains 10 fields and 2000 records. I want to do some changes to the second field in with a certain criteria. I used PUT command and the values are changed, but it always corrupts the next record, rest of the file remains OK. any...

Hello Is there a way to get the data and header from from SQL in clarion. for example: SQLFile{PROP:SQL}='SELECT field1 as F1,field2 as My_SecondField FROM table1' I want to to retrieve the data including the header (F1,My_SecondField ,.... etc) I could do that with VB but failed with...

Thanks. I will do some tests and infom you Best regards

thank you oxidadus and I really appreciate the followup. I checked that but still it is the same first method. the difference between the first and the second is that in the second method I don't have to pass the the parameters in same sequence of the stored procedure. so if I execute the...

Hi, thank you for your reply. may be my idea was not clear, what I need is sending the parameters using this exact method defined by @variables exec sk_test5 @bb='--Para2--',@aa='--Para1--',@Result = @myresult OUTPUT without having to send the parameters in sequence or all of them. the actual...

I found it. it should be in Other Declarations embed as: MAP ProcdureName PROCEDURE END

Hello, any idea how to map the local procedures, i tried to put it in the .clw module adding my local map to the "Start of Module" embed but it didn't work. thanks

Dear All, is there a way to Override the LEFT() function in Clarion? my problem that I used it in so many applications with noticing its behavior with spaces as I used it like any other language to extract the a number of characters from the beginning of a string regardless that there could be...

thank you .. so appreciated

Dear All, I used to use variable# (Long) and variable" (String) as temp variables, I remember there are other symbols beside # and " does anybody remember these. Regards

Hello everybody, anyone has an idea how to display time with milliseconds in clarion 6.3 Best Regards

Dear All I use my own SQL stored procedures using the CALL command sending the parameters from clarion and getting results and everything was fine. now we have a third party stored procedure with a lot of parameters and calling the stored procedure using the variable definition. this a...

Dear All, this question is about writing inside the template lines, I will an example: in application for writing on line in multiple line we use '|' mark; for example: String = 'this is a sample for breaking lines' can be written a String = 'this is a sample for ' | & ' breaking...

Hi, I have this code to run and application (notepad for example) and if it is already running I want to set focus on it. Set objShell = CreateObject("WScript.Shell") Set objWMIService = GetObject("winmgmts:\\.\root\cimv2") strQuery = "Select * from Win32_Process" Set ColItems =...

Dear Cagiv, thank you but this not what I meant. I want to embed the code inside my application without having an external application. thanks again. Regards

thank you guitarzan for the links regards

Actually I am collecting data from different locations with different types of data and at the end I do some calculations and statistics then I flush the data according to user choice either to text file,excel file or SQL database, in fact I can output them to a temp text file and reuse it after...

Hi, I joined this forum today. if your problem was not solved yet, can you put a sample of the file you are trying to import. I may could give some help. Regards

Hello everybody, I wonder is there a way or work around to use vb-script with clarion (I am using clarion 6.3) any suggestion is highly appreciated. Regards

this is what I used to fill the array, but is there any faster or better way to do this? Set objFSO = CreateObject("Scripting.FileSystemObject") nn = objFSO.Drives.Count Dim arr() ReDim arr(nn) x=0 For Each objDrive In objFSO.Drives x=x+1 arr(x)= objDrive.DriveLetter Next