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

Search results for query: *

  1. sk2107c

    modifying a value in a text file opened using Basic driver

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

    Getting result Header From SQL statement using clarion

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

    Calling MSSQL stored procedure with OUTPUT procedure from clarion

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

    Calling MSSQL stored procedure with OUTPUT procedure from clarion

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

    Calling MSSQL stored procedure with OUTPUT procedure from clarion

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

    Using Local procedure

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

    Using Local procedure

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

    Override LEFT() function in Clarion

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

    temp variables in clarion

    thank you .. so appreciated
  10. sk2107c

    temp variables in clarion

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

    display time with milliseconds

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

    Calling MSSQL stored procedure with OUTPUT procedure from clarion

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

    Breaking lines in template file

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

    Set Focus to an open application

    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 =...
  15. sk2107c

    using vb-script with clarion

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

    use for...to.. next in stead of for each..next

    thank you guitarzan for the links regards
  17. sk2107c

    use for...to.. next in stead of for each..next

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

    Clarion - Dictionary - Basic File - Import CSV to TPS

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

    using vb-script with clarion

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

    use for...to.. next in stead of for each..next

    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

Part and Inventory Search

Back
Top