Recent content by fumbles

Hi - Can anyone let me know a reliable way to find the numeric position of a character or string within another string. In crystal, I can use the instr(ing) function to return the location of one string within another. I am not seeing anything like that in progess. Hopefully there is one...

thanks Michael - tweaked a little and it worked.

Hi All - I need to import values from a csv or excel into an existing field in an existing table in our database. We are updating price records in excel and would like to load them into an existing user field in the item table so we can do a bulk replace when the new pricelist date occurs. I...

Sorry to be so late in responding - we're fighting with an uncooperative erp implementation. Works like a charm! Thanks again Steve

Hi All - I am brand new to Crystal and have to extract one string from a two line array from our Progress database. When I put the field on a report a get the first line ending wiht a ";" . I have no idea how to get to the second line. I'm using Crystal 11 The help for the ERP software...

This is likely a very rookie question, but I am very out of my area of experience. I'm using MAS200 for ERP at a distribution company. I am trying to use Crystal 8.5 to generate a report that will show the detail of various notes stored on the customer, item, po records etc. I am not very...

Hi all - If this is really elementary, I plead ignorance in advance. I am trying to create a remote view of a MAS 90 table from VFP 7 on a LAN. I get to the point where I have selected a table from the list of tables. I am getting a "Connectivity error. [ProvideX][ODBC Driver]unexpected...

We have not experienced that problem since we separated the data from the operating application files. We have an 8 user system with everything from Win 95 to XP Pro. All the users have the exe, supporting runtime files, config file and their own foxuser file on the local machine. Only the...

Ramani & Baltman... As always thank you for your prompt help. I tested both of your ideas and in the process, while changing my approach to use Ramani's suggestion, I discovered a duplicate record in a related table. Eliminating the duplicate removed the symptom. Thanks again. Steve

Hi all - This is probably something very simple but I am stumped. I have a query that I run over a sales detail table. Two of the fields are numeric 8,2 ( amount and cost ). When the query encounters a reversing entry where 499.00 becomes -499.00 and 251.25 becomes -251.25 ( the reversing...

Serincino - Wouldn't the valid event be a good place to evaluate the account number. That way focus won't leave the account number until you are ready. Steve

Have the user indicate copies to a variable or property and use a "for loop" for i to l_ncopies repo form ????? endfor Steve

Hi John - Trying to decide which road to take, that's why programmers make the "big money" :). Do you have a feeling for how many different formats are involved? I would think that maintaining many different sets of @say output would be harder - especially for subsequent changes to...

Hi John - If the report can "see" the form type ( global variable or control file setting ) use the PrintWhen dialog ie. g_ccurrentform = "123" or sysconfig.FormUsed = "234" Put both field locations on your report. Steve

Irwin - In my retail system check printing routine, I created two different reports, one for the detail and one for the voucher, then ran them over the same data set as many times as needed. This allows you to keep track of detail lines so that in one check paying multiple invoices you could...