Search results for query: *

I have a form with a pageframe and two pages. In the form load, I load up a cursor. The cursor is used on Page1 in a listbox. I have a command button to processes a transaction based on what record is selected in the listbox. What would the best way to update the cursor be? I basically need...

Can anyone identify any problems with this query? The last little piece of my select you can see I'm adding T1.LABOR, T2.PURCHASESTOT, and T3.MOCOST. Everything seems to work great, except for when one of these fields are empty/zero, my total will always be zero. If all fields have a value...

Hello everyone! My question pertains to incremental searches using a text box. On my form I have a text box, and a list box. The list box contains my record set, and the text box allows for incremental searching of my records. So far it works great, except I need to "Tab" or "Enter" to get...

Hello Everyone, I'm looking for suggestions as to what I should use for a clock. I currently have several users that RDP to a server where our ERP is hosted, and they use it for attendance and labor capture. The problem that I have is because I have the taskbar disabled, so when clocking...

So the longer I stare at this the more I confuse myself. I'm working with two grids, on two separate pages of a single pageframe. The grid on page2 is dependent on the record selected in page1. The problem I'm having is if I build my cursors on the form.load the page2 cursor take forever...

Does anyone have any experience using the GridExtras class by Craig Boyd? I've used it a number of times and it works great! On my Form I have a single pageframe with two pages and one grid each. The first grid exports just fine, but the second will only export the column names. If reverse...

Here is what my data looks like: ID | LOCATION 123, A1 123, Z8 123, Q3 123, B1 123, N4 124, A6 124, A7 124, A8 124, Z0 124, Q5 I need this: ID | LOCATION1 | LOCATION2 | LOCATION3 | LOCATION4 | LOCATION5 | 123, A1, Z8, Q3, B1, N4 124, A6, A7, A8, Z0, Q5 I tried to run this query with GENXTAB...

Is it possible to optimize the code below? Would I be better of creating multiple cursors and joining the cursors? Currently I'm just filling a grid with the result of this query. It takes about 13-15 seconds to execute, which really isn't long but would like to reduce this as much as...

I have a fairly large SQL query that I'm trying to combine with a SCAN/REPLACE. SELECT material.orderno, material.pn, material.wc, material.duedate, labor.status, order.status, labor.startdate, labor.pn FROM (labor INNER JOIN material ON ((labor.orderno=material.orderno) AND...

I am trying to full join two tables through ODBC but can't seem to get the syntax right, or maybe it's not supported? select t1.PN, t1.fqty, t2.cqty from (select pn,sum(qty) as fqty from invloc where warehouse ="FLORIDA" group by pn) t1 full outer join (select pn,sum(qty) as cqty from...

In my table I have a memo field that looks something like this: "1234",3.0,F,T (I have 400 lines of this in each memo field) I only need to see lines from the memo field that contain T,T or T,F or F,T. What would be the best way to handle this, I would send to excel however I still need to...

One of my fields is a memo field that contains 3-20+ lines. I'm trying to break each line out into it's own record, so far what I have done is created 20 formulas such as: "Split( {codet.optdisp}, Chr(13) )[3]" I don't need the first two lines so I started with the third. This works fine but...

Ok, so I went and picked up a copy of CrysDev and put together a VFP form with the Crystal viewer on it. I have it all working great, now I would like to expand and have one of my parameters filled in (instead of prompting). I read through this book a dozen times and I'm totally confused on...

Happy Thursday everyone! I just completed my calendar report based on LBASS's method discussed here: http://www.tek-tips.com/viewthread.cfm?qid=1475890 It is working beautifully so far except in the case when I do not have any records for a particular week, or the entire month. If I do not...

Does anyone have a sample form/program they're using to launch a crystal reports preview? I've been trying non stop for several hours to get Craig Berntson's code to work but I must be missing something.