Search results for query: *

Hello I am having the same problem that ido is talking about here. Can you take a look at my sql. i get the error when i have two left outer joins b/c of the null values? how can i correct this? SELECT TK_CUSTOMER1."MAIL_ADDR1", TK_CUSTOMER1."MAIL_ADDR2&quot...

turk bear i am looking to do the same thing. i have a field in a report that is an email field. is there a way to pull this off the report into the to: portion of the email?

I need to suppress a field if the data returned is null. How can i do this?

Question: I am using this code below. I need to add another array because I exceed the 1000 limit with data I am pulling from my database. Can anyone help me on this? Setup array formula: WhilePrintingRecords ; global numbervar seat_array_position := 0; global stringvar array out_list :=...

Question: I am using this code below. I need to add another array because I exceed the 1000 limit with data I am pulling from my database. Can anyone help me on this? Setup array formula: WhilePrintingRecords ; global numbervar seat_array_position := 0; global stringvar array out_list :=...

I am running this code: stringvar array times:=split({Field2}," "); numbervar loops:=ubound(times); numbervar i; stringvar out; for i:= 1 to loops do( stringvar chnge:=times ;//3:308:1:18,6 stringvar end:= mid(chnge,instrrev(chnge,":")+1); stringvar...

huh

I need to build a query that splits up records into three fields. this is the field: 2:268:22:11,1 2:268:20:4,1 2:268:21:12,1 2:268:22:12,12 2:268:21:13,13 i need it to go into three seperate fields SB1 SB2 SB3 based on the spaces between the origial field is this possible? the data...

HELP! I have a report with a table as its recordsource. In the report I have $0.00 values. I would like to hide all the zero values. IS THIS POSSIBLE...