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...
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...
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...
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
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.