Search results for query: *

I think I figured it out: select t1.district, t1.order_no, t1.tr_date, sum(case when t2.tr_date <= t1.tr_date then 1 else 0 end) as tr_seq from tbl_example t1 inner join (select district, order_no, tr_date from...

I have a table that stores (among other things) district number and order number. Each order can have multiple transaction dates (each time it has been touched). What I need is a SELECT statement that can give me an ascending sequence for each record grouped by district and order. So if the...

Thanks again for your help, but unfortunately it didn't work. I was no longer getting a syntax error, but the dialog still wouldn't close. I played around with a few things and what I finally came up with was this: Function dlgFNRFunc(identifier$, action, suppvalue) dlgFNRFunc = True...

Thanks for the reply, but I had tried something similar before and just tried your code as well, but I get a compile error "Syntax Error" on the CancelButton 67, 88, 50, 14 .BtnCNCL line. Is there something else I need to do? Syntax Error is awfully unhelpful, but since the only thing that...

I have inherited several macros from my predecessors. One in particular is giving me a hard time. It never had a cancel button before, only an OK. I've tried coding one in and it appears just fine, but it doesn't actually do anything. I'm afraid I don't understand the rest of the code well...

I know that VBScript can communicate directly to a database through ADO connections and SQL. Is there anyway to get the VB-like macro language of Attachmate to do the same? Alternatively, is there a way to pass variables from the macro script to a .VBS file if you can't connect to a database...

We have field users who send messages to us through Attachmate, and message center personnel who receive and respond to those messages, also through Attachmate. We've been using a macro bound to the "Enter" key to record messages and replies. The macro uses GetString to grab information from...