solinox Message Board Activity

You might try the subtract/add routine and see how it works with your data. My understanding is that subtract looks at the fields that are similar between the two tables, anything that *could* be a key, not just a declared primary key. And since it appears that your fields have the same names, an Add() should put everything in the right place. I'd be interested to find out if that routine works with your data.

Posted to MB Topic: ObjectPAL « Paradox Board

There has got to be a more elegant solution to this than the one I've come up with...I hope! Here's the situation:, , I have a main table of data on contracts. Two of the fields, for days and hours, now need to be broken down into month-by-month entries, with the total displayed on the main screen. Displaying the total is not a problem, that's just a summary field. The problem I'm having is in managing those separate entries., , I created a new table for the entries. It is keyed off two ID fields that match with the main database, plus the month field. So we have:, , [list], [*]PCA -- Alpha, keyed, [*]PF -- Alpha, keyed, [*]Month -- Alpha, keyed, [*]Days -- Numeric, [*]Hours -- Numeric, [/list], I have one button next to the summary fields on the main screen. I want this button to bring up a screen that displays a tableframe showing Month, Days, and Hours, so the user can edit these fields. In the background, it should be maintaining the appropriate PCA/PF numbers so that the ...

Posted to MB Topic: ObjectPAL « Paradox Board

Table 1 wouldn't have a month field in it. These items would span multiple months. So Table 2 shouldn't need an additional identifier beyond the Month field, because there's only going to be one entry per month., , To get back to the real problem, though, if I "officially" declare relations between the PCA/PF fields in the two tables, will it then automatically fill in those fields on the input form even though it's a separate form with a separate cursor? I've been able to do this before if I had my subtable actually on the main form, but I don't really have room for it this time so it needs it's own screen.

Posted to MB Topic: ObjectPAL « Paradox Board

Do you have more than one row of tabs? If you do, the notebook will always place the currently selected row on the bottom. If you go into the properties page for your notebook object and tell it to have 8 tabs across, you'll only have one row and they won't move around like that., , Then you just have to figure out how to make your labels fit!

Posted to MB Topic: ObjectPAL « Paradox Board

I use a form with a notebook with 8 tabs. When I click on tabs they will shuffle around. How can I set them in permanent static order on screen. Thanks!

Posted to MB Topic: ObjectPAL « Paradox Board

As far as I know, it can't be done. Which is not to say it can't be done, of course. Perhaps you could pull your 10 records from Matchcode into a separate temp table and use that table in an outer join?

Posted to MB Topic: QBE & SQL « Paradox Board

Access also has an AutoNumber field type, if you are actually building your database design in Access. This will automatically generate a unique number for each new record, without any coding on your part. I don't have Access in front of me right now, but I believe it's a type Long.

Posted to MB Topic: VB Classic Other « VB Classic Board

I am working with access (not one of the DB that I know very well). I am trying to generate a 16 digit unique random number as the key. Anyone have any suggestions.

Posted to MB Topic: VB Classic Other « VB Classic Board

This error is occuring when a VB6 project is run, before the first line of execution:, , Unexpected Error (713), , The project runs fine on another PC. The project uses Crystal Reports, maybe that has something to do with it.... Any ideas? , , Thanks,, Ray

Posted to MB Topic: VB Classic Other « VB Classic Board

Have you tried using the Err collection in an error handling routine to get a more detailed description of the error? Or does the error come up before you can even get to an "On Error" statement?, , What version of Crystal Reports are you using and what kind of database are you accessing and how?

Posted to MB Topic: VB Classic Other « VB Classic Board

Hello all, since I started posting I'd better introduce myself!, , I'm been programming all my life, and working with various databases for the last 4-5 years. Usually I work with Visual Basic, running either Access or SQL Server databases. This year, I'm getting some Paradox contracts. I generally love a challenge and learning new things, but I have to admit I'm not becoming overly fond of Paradox! Still, I'm happy to share what I've learned and hopefully get some tips from everybody else.

Posted to MB Topic: Member Introductions « PrestwoodBoards Board

How are you loading the data into your grid? If you use a SQL query in your code (as opposed to selecting tables from the Properties window), you can add a calculated TOTAL field to the table that is returned to the grid.

Posted to MB Topic: VB Classic Control Usage and Developing « VB Classic Board

Ok, thanks, that works. I was trying to put the blank() in the wrong place.

Posted to MB Topic: ObjectPAL « Paradox Board

I've got a form that I'm using to display an image from my database. The image is actually stored as a file name and path. Then when I open the form, I assign that file name and path to my Graphics tool to see the image., , The problem I'm having arises when I want to delete the image from my database. Actually deleting it from the database isn't a problem, but I can't figure out how to get the Graphics tool to revert to a blank display. It chokes if I send a blank string to the same Value property I send the graphic filename to., , Suggestions?

Posted to MB Topic: ObjectPAL « Paradox Board