LiveCode Forums.

Hi, I solved the problem with: and it works fine.

I really should have thought about that one before I posted but many thanks anyway.

Hi, I have a problem with a part of my code but this problem only occurs sometimes, I have a stack that updates an Excel file, this stack gets its data from my main stack, basically what happens is this: rs("Comments") = "This person has demonstrated a very high level of skill and determination to c...

Hi Sparkout, I didn't see your post, so I used this method instead: put "rs(" & QUOTE & "First" & QUOTE & ")" & " " & "=" & " " & QUOTE & fld "First" & QUOTE into tFirst put tFirst into line 15 of tScript i works perfectly and it does pretty much the same thing as your post, it just goes about it in...

Hi Sparkout, zryip theSlug - yeah, I have an ADO vbscript to write to excel and it works fine from my vbs editor, the problem is that i'm trying to use the replace fld "First" with fld "First" in tScript as i do in access, however the field in the script has rs.("first"), is there a way to lose the ...

Sparkout, you're a star!, works perfectly both sending to and receiving from,
VERY MANY THANKS INDEED!!!

kindest regards

WeeWullie

Hi Sparkout, i'm trying to test the code from Ken Rae's awesome Sonsothunder site, for sending to and getting from excel, i am probably missing something obvious here, i have attached the rev file as follows: any help would be very appreciated.

Kind regards
WeeWullie

I'm trying to use the excel vbscript from Ken Rae's http://www.sonsothunder.com/devres/revo ... iac001.htm site,

i get an error when i test it, does anyone know if this code needs to be updated?

Indeed it certainly was Klaus

its good that you can use both methods, transcript is very flexible, i love it!!!

cheers Klaus

Hi Klaus, i tried to use this: on mouseUp open stack "FTdoc" put "FTr" && "--" && fld "firstname" of stack "FTDoc" && fld "lastname" of stack "FTDoc"into fld "Subject" of stack "myStack" put urlencode( "TrType:" && the selectedText of btn "TrType" of stack "FTDoc" & cr & "TkType:" && the Text of fld...

Hi Klaus, i tried to use urlencode for the entire string and just the variable and it doesn't seem to work, this is the string: put "Tr Type:" && the selectedText of btn "TrType" of stack "myStack" & cr & "Tk Type:" && the Text of fld "TkType" of stack "myStack" into tParr perhaps i'm missing someth...

I am trying to export text from a stack to a vb file , one of the fields has two lines of text in it, the problem is that when i try to send the data both lines are included in the string, starting and ending with a " but because i use a cr to put it into two lines it wont send it, i need each line ...

Nice 1 Bernd, that works perfectly, and thanks to all, i have attached the date picker i use, as i said in an earlier post this date picker was originally on revonline by Marty and was subsequently modified by BVG, i use it in lots of stacks and it works well.

king regards

wee

Hi everyone, i managed to solve my problem by dissecting the system date and re-arranging char by char and removing the first 2 digits of the year item, the code i used is thus: put text of fld "Date1" into tDate put char 4 to 5 of tDate & "/" & char 1 to 2 of tDate & "/" & char 9 to 10 of tDate int...

Try this in a button script: on mouseUp put getDayOfWeek(the date) into tDay answer "Today is:" && item tDay of "Sun,Mon,Tue,Wed,Thu,Fri,Sat" end mouseUp function getDayOfWeek var convert var to dateItems return item 7 of var end getDayOfWeek Set a breakpoint at the "on mouseUp" line, and "step int...

Hi wee, to use what Klaus did in his function and put it into a mouseUp handler here is what works for me. on mouseUp put text of fld "Date1" into tDate set the itemDelimiter to "/" -- this lets you treat a slash as itemDelimiter put item 2 of tDate into item 1 of tDestFormat -- items are automatic...