Recent content by cmorgan

If you want to replace multiple characters with different values, you might also want to take a look at the SUBSTITUTE function.

You should be able to get the client's name from the _Connect VST. Then you can do an nslookup to get the IP. HTH

I don't know much about performance tuning on Windoze, but here are a couple of things to look at. First, you mention that you are using AppServer on this Win2K box. Are the clients and the databases also on this same box? If not, how is the AppServer connecting to the database, and where...

Whoa. You can't bring a database directly from linux to Windoze. You'll need to dump and load if you want to change platforms.

Pete, OE will take advantage of whatever processing power the OS gives it. Whether you have 1, 2 or 4 processors is transparent to the RDBMS (athough you can use -spin to tune performce for mult-processor systems). Assuming you are using a 32bit OS, each database can only reference (about)...

Try something like this: do i = 1 to num-entries( temp1, " " ): create tablename. assign tablename.fieldname = entry( i, temp1, " " ). end. /** i **/ HTH !

In the past when PSC has dropped support for a platform (VMS, CTOS, etc) they have waived the platform change fee for users of those platforms. Solaris Intel and SCO Openserver are likely candidates for this exception in the near future.

<I>There is a server running for this database. I know this because Tyler know's this.</I> Really? Try 'pro' instead of 'mpro', just to be sure.

There are a few new things: 1) 4 action segments instead of one, addressing the 64k limit. 2) The 2Gig file size limitation is gone. 3) Intellistream (an instalation/update manager for WebClient) There are probably more new features and bug fixes, but these are the ones I can...

If this is a one-time event, you might be better off writing a 4gl procedure to export the data to a text or csv file, and then loading that into Access. What type of progress license do you have?

How about this: Def var x as char no-undo. assign x = freply("andré") for each table where table.name matches ( "*" + x + "*" ) no-lock: create table2.....etc etc.... end.

I know it isn't an ideal solution, but you could try something like <PRE><BIG> display "a" matches replace( YourString, "á", "a" ). </BIG></PRE> You could even write a function to handle all of the relevant replacements, so you could write <PRE><BIG> FUNCTION ReplFunction returns...

If status default doesn't work try status input. status input "Your message here". You could also try changing the help message for the field in question: YourField:HELP = "".

Try adding a status default and/or status input line. For instance: status defualt "processing...". or even status default "". HTH

The symptoms you are describing could be the result of defining your selection list with LIST-ITEMS instead of LIST-ITEM-PAIRS. Also, be aware that there is a bug with LIST-ITEM-PAIRS, where you cannot use the same description twice for different values. HTH