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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: JJB81
  • Order by date
  1. JJB81

    outer joins

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

    Email Reports

    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?
  3. JJB81

    Suppress if Records are Not Null

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

    dynamic array and MSchart???

    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 :=...
  5. JJB81

    Loop and counting

    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 :=...
  6. JJB81

    Exporting automatically when report is ran

    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...
  7. JJB81

    Loops in SQL?

    huh
  8. JJB81

    Loops in SQL?

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

    Report Label Question?

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

Part and Inventory Search

Back
Top