Search results for query: *

Did you mean Cast()?

Your problem here is that CLEAR EVENTS is being blocked from properly exiting your application. You've somehow created an object reference to a form or some other object (in a public variable, member of _Screen, whatever) that cannot be released when CLEAR EVENTS tells all programs to stop...

It's been 20 years since I brushed up against Lotus Notes. At that time a consultant recommended to us by a VP at Lotus told me "you'll never be able to get data from Notes without a custom API I'll write for you". Phooey on that. The day they installed Notes on my computer I started...

REINDEX But that's pretty much the only time I've used it in the last 25 years. [pipe]

NULL actually has meaning, depending on the circumstances. In a system logging results of medical tests, an empty numeric field will evaluate as numeric 0. What if the test was not administered that day? The 0 skews averages. A NULL in the field indicates no result for that day. This was...

Guys, the INDEX syntax listed above: index on sono+STR(lineno,4)to sono1 Syntax error aside, this will not create a CDX. It will create a standalone IDX. This shouldn't upset an existing application's CDX files. HOWEVER, if the existing application expects IDX files all bets are off. I'll...

Nulls are NOT empty. They have meaning in truly relational databases. SET NULLDISPLAY was introduced early in the FB implementation of NULL to help us "cheat" the use of actual nulls. It's better to change your query (as Tamar showed) to avoid null in the result than to alter your data or the...

Yeah, this is a very ambiguous question that MIGHT be answered by setting up a simple mailmerge in Word. More feedback is needed for anyone to be of any help at all.

If the user has Windows set to its default (auto-arrange) you shouldn't mess with it. Desktop arrangement belongs to the user.

There may not be any visible place to type on screen, but that's only because it got moved off screen. It's still there as you've found. Glad to hear it helped!

After you start it, try MOVE WINDOW SCREEN CENTER MOVE WINDOW COMMAND CENTER (Type carefully)

It started in dBase so of course it's valid. You can even use it for object references: WAIT WINDOW THISFORM->CAPTION It's just SO much harder to type than . [pipe]

You *might* get better performance using fcreate() trying to create a file there, but failure wouldn't actually tell you whether the directory exists. You just might not have rights. The long hang isn't coming from Foxpro. It's just waiting for the operating system, and Windows has a long...

Use an edit box instead. If you want it to look like a textbox, size it appropriately and turn off the scrollbars.

Terminology will slay us all. Technically, that blinky vertical line is called the insertion point, not the cursor. Likewise, that arrow thing-o you drag around with the mouse isn't a cursor either. It's a pointer. Remember what Henry Higgins said of English: In America they haven't spoken it...

Same here. (With dbf corruption as well.) But I've had clients who can seemingly corrupt them at will. [glasses]

You should be using Stonefield Database Toolkit. It maintains metadata about your structures and indexes and handles "pack & reindex" for you.

Olaf, it's true that only the scope will be optimized. But remember that every scoped command has a default scope. The default scope for REPLACE is NEXT 1. The default scope for REPORT FORM is ALL. The default scope for SCAN is ALL. So, really, the command is always scoped.

When you want a permanent collection of index tags that may or may not be up to date. [shadeshappy] The whole mechanism came about when some people complained about being FORCED to use the structural CDX during early alpha/beta cycles when the feature was new. I've never used a second CDX. If...

SCAN/ENDSCAN has another advantage Mike didn't mention. It's subtle. The command is scoped. That is, it supports FOR, WHILE, REST and NEXT <N> as part of the command. That makes it "set-oriented" and it also makes it Rushmore optimized. It's so doggone useful I can't remember the last time I...