FiveTech Software tech support forums

Mike, I guess I wasn't clear, all you have to do is use automatic primary keys with DBFs. You do this by using the field type "+" for the primary key field. Then when you add a blank record it will automatically get a primary key ID. This way you can use the same code for both DBFs and SQL...

Most databases automatically create the primary key when a new record is added. Thus they won't allow you to update the primary key.

DBFs are the exception to this, however there is now the option to specify an automatic primary key for DBFs too.

Hmm, I don't think you can enter an invalid date into a date variable type. Have to tried that? Otherwise here is a test. Note that when a character date is converted to a date format date, if it is invalid it will be an empty date (" / / "). It is still a date data type but it is empty. #...

Marc, From a previous post near the top of this message topic you said: I used DATABASE oKlant // my early way and then stuff for oKlant I see many times : oCustomers:= TDatabase():New(,"temp",,.f.) oCustomers:use() Is the second way the way it should be done in order to use ALL options in...

Marc, Well this seems to be an example of how to edit the properties of a database. I would not get sidetracked with that right now in your learning curve. Most object programming texts advocate separating the interface code from real-world objects. Thus a customer object should emulate a real-world...

DATABASE oKlant // my early way and then stuff for oKlant I see many times : oCustomers:= TDatabase():New(,"temp",,.f.) oCustomers:use() Is the second way the way it should be done in order to use ALL options in FWH or is it the same ? You can use all options of the database when it is an...

Marc, You really need to avoid filters. Filters require reading the entire database each time you call them. So for an incremental search of 10 characters you are going to read the entire database 10 times. Even if you don't do an incremental search, you still have to read the entire database using ...

Marc,

Are you using filters or scopes?

Are you doing incremental searches on a Get as the user types?

Are you trying to update five browses for each keystroke the user types into a search field?

Many things we did when the exe and databases were on the same computer are not practical on a network.

Marc, You gave me a laugh when I saw your message directed at me-you knew I would say OOP. Good, at least you remember. Note that back in Clipper era with 16bit computers without much memory we were limited as to how many files we could have open at one time. This rarely an issue now. so you can ope...

Have you tried oClip:setText() and oClip:getText()?

Why not just use a variable instead of the clipboard?

James

Enrico,

You don't have to modify the source, you can subclass instead.

James

You can also avoid these kinds of problems by using database objects. Every database object creates its own unique workarea and handles it internally. Thus you never have to deal with workareas.

Otto, Wow, your xbrowse looks so much better than listbox. I switched from listbox as soon as xbrowse came out. The main reason was that listbox didn't support larger type sizes since the height of the lines couldn't be changed. Plus xbrowse is so much more powerful. I like your color scheme. Users ...

Enrico, Maybe you can explain a little about what you want it to do. Normal windows in Windows software already adapt to screen size. Are you looking for something specific that is not working the way the customer wants? If, so please describe it. If you don't know where you are going, any road will...

Enrico,

Close your eyes and tap your heels together three times... -From the Wizard of Oz