Paradox Tables Topic

{Too Long!}

Howdy.  I've got a form that I use for dataEntry.  When I use a dialogBox routine, the Pdox menu changes and when I close the dialogBox, those menu changes remain with my main form.  The important thing for me here is that I lose the capability to use Filters.  I have not found a way to reset the menu to the correct one.  Any ideas?  Thanks.

I am trying to get graphics data into a table - envision a Movie database and I want to include DVD art into the table.  I am able to get the graphic into the clipboard and then paste it into the table.  Everything appears to be fine until I leave that record - then the graphics that I could previously see is no more.  I've tried everything that I can think of within native Pdox and nothing helps.  Any ideas?  Thanks.

Hi all, I have been trying to solve this one for a while without success. I receive pricelists from distributors that I convert to PDox9 tables, then perform searches for Product IDs to modify my internal table. All works perfectly well, except for the times when the Alpha field I am searching contains a parenthesis " ( or ) " . In this case the search is unable to match the record. I do not see this problem with fields containing  # /.  - = etc. I am using advancedWildcardsInLocate(Yes) for the session. Any way around this? I am unable to change the fields as they are manufacturer product IDs. Thanks in advance, Grant

I've been using Database Desktop for years to maintain Paradox tables, but it now appears that DBD doesn't work on Windows 10 for build 1703 or later.  Is there an updated DBD that does work?  Or is there an alternative tool I can use?  I've found several tools that will let me view and modify the data in Paradox tables, but none that will let me modify the table structures.  Any suggestions?

{Too Long!}

Upgraded a win 7 box to win 10.  Using a win 7 client.  Now recieve the error: Cannot open: :dbx:table.db No More files. Table: table.db Table: \\earth\database\xxx Happens both manually and programatically.  Can usually get it to work if I quickly try to access same table/query again.  The longer I wait before retrying the greater the chance it will error again. I see some similar issues online after Win 10 updates. Do we have a fix?

{Too Long!}

I have experienced the disappearance of ALL memo field values (multiple memo fields, thousands of records) in at least one table (although the *.Mxx files still exist). Based on info from another, old thread, I understand that there‘s neither a "built-in recovery tool" nor a "simple recovery process" to re-attach .Mxx files to a .DB, but where might I find the explanation of a tool or process--regardless of complexity--to explain how to do it myself? Thanks in advance for any help! Aloha, Philip T. (PT@PhilipT.com)

I have been away from Paradox for a few months, but am in the process of updating some of my old work., , I was wondering how I would set a memo-field to accept "Returns", or to simulate a line break from the keyboard., Users enter brief trip reports and have been complaining they cannot separate their paragraphs properly. I haven't been able to find any properties which look promising, but I'm sure this problem has been solved in some way or another on this board. , , Thanks in advance, Eric

Hi together,, iam searching for an example, how i can get an access to a Paradox 5 with Java., I hope someone can help me. Thanks for all comments.

I need to open a data table and run through it checking a particular field for matches in a separate look up table. I need to flip repeatedly between two open tCursors. I declared my two tCursors and opened them expecting them to open independently, like so: tc.open("one") get the string tc2.open("two"), expecting two to be opened in another work area. search a match for the string in Two's FIND field if found manipulate the string tc2.close() update one's data with the string, expecting one to just be there and selected. move to the next record and repeat What am I missing in the way these tables/tcursors need to be opened or selected? The way it is now tc2 doesn't seem to be being selected when it's opened. NONE of code examples I checked online used two tCursors in the same code block.

Paradox 11.0.0.411 stringList.setString ( const stringID longInt, const stringValue string ) logical   Is there a documentation error here.  And for that matter does anyone have information to documentation updates/changes?   I seem to be able only to use a smallInt.    

Our web application queries the Paradox tables through JDBC every 30 minutes to update our local copy of the data. This scheduled query will run, for about a day and a half before it starts failing with this error:, , Error message: Error while trying to connect to database, Exception message:, While trying to obtain Connection object, there was a ProviderFailure exception on the server., Following are BDE Error messages:, BDE ERROR CODE: 9488 MESSAGE: Too many sessions., , We are closing all connections and database resources after the update is finished. For, some reason, the server is running out of resources., , Is increasing the number of sessions in APPSRV~1.pro from the default 45 to a higher number the right direction to address this issue?, , Bob G.

Attempting to add data fields to a table and I get invalid parameter error. Error refers to links between tables. I do utilize lookup tables on the form when adding data to this table which is functioning without any issues

We have an accounting table that has reached the one million seat. When we export this table to another program called contaplus we obtain an error "Seat number of accounting entry 1000001 is incorrect". we do not know how to start again with the accounting entry 1 or if there is a counter to zero this table ..., But the problem is that right now we do not have Paradox programmer. I can't upload images, a mistake comes up. Thanks in advanced!

I am suddenly getting an error when I try to post a record to a table.  The code is 30463. How do I find out what this means and what causes it?

my problem of being unable to open tables because the file name is too long for a version 5 table - I've read in one of my texts that the later versions support long file names.  All I want to do is open the tables.  Since I've had no reply to a way to change the cumulative pathways, could there be another option?  Is there a way to change the tables from the earlier version that doesn't support long file names to my later version 11 Paradox.  Lacking a way to do this the  easy way (I couldn't find anything in the literature to do this, i.e. changing the table version), would it be possible to find out exactly the original paradox version of the table, copy the table to that version so it would open.  Then would there be a way to import the table data to a table constructed under the new version (the design duplicated from the table opened in the earlier non-long file name version).

{Too Long!}

Hi all, I would like to know if there is any way I can export the structure of all the tables from paradox using script and save as .txt. Appreciate an early response.

Is it possible to design a Paradox Report in such a way that if a record meets a particular criteria, the colour of the record can be changed. Ross

Using version 10, when I try and run the table repair utility, I get a message that state "Invalid Alias" and the table repair won't run. What gives? Anyone else run into this? Is there a work around?, , Any help would be appreciated.

I have been using Paradox 9 for some time. Recently I messed my self up someway ......and my PRIV Alias Path got changed. I want to be able to change its Path. It Seems Paradox 9 will not allow me to change The PRIV Alias. Any Help would be welcome.  Larry Dunn Kenmore, NY

Hi Everyone, I am running Paradox 11 under windows 7/64.  When I put Windows 7/64 in I had no end of problems with software that would not run on it.  Fortunately, Paradox did.  My question is, "is anyone continuing to develop Paradox Win, other than Corel or is it's future compatibility dependent  on them.  As I understand it, there has been very little development work on Paradox since version 9.  What has been done is virtually tweaks.  Am I right?  Does anyone have any thoughts on the subject?

When I want to open the files on my server I get the message; "You have attempted to open a database that is in use by someone else, but data can't be shared. You must set the location for the .NET Control file." Of course the file is not in use by anyone else.  I appreciate knowing your suggestions/replies for how to set the .NET Control File location. Thanks