I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

Paradox Tables Topic

Paradox table structure, TUtility/Table Repair, and related including accessing Paradox tables from Delphi, .Net, Java, VB, etc.
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Bob Stubbs
filter button disappears when using dialogBox
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.
27 days ago
3 replies. Last post:

Steven.G
you don't want to generically mask something that's wrong.. there's a focus issue here.. are you sure the dialog isn't just minimized, or hiding under the form?
27 days ago
Nothing New Since Your Last Visit
33
Hits

Thread 24 of 25
Thread Starter  

Bob Stubbs
Keeping graphics in Pdox table
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.
33 days ago
3 replies. Last post:

Bob.S7
OK - thanks.  That pointed me in the direction that I needed to get.
27 days ago
Nothing New Since Your Last Visit
24
Hits

Thread 23 of 25
Thread Starter  

grantr
String search and match with ()
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
9 months ago
1 Reply:

grantr
Please ignore. I ended up solving it after adding the advancedWildcardsInLocate(Yes), and then changing from locatePattern() to simply locate(). I probably made the change prior for some reason haha. Grant
9 months ago
Nothing New Since Your Last Visit
176
Hits

Thread 22 of 25
Thread Starter  

Bob S.
Database Desktop on Windows 10
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?
36 months ago
9 replies. Last post:

Jeff.R3
{Too Long!}
11 months ago
Nothing New Since Your Last Visit
2151
Hits

Thread 21 of 25
Thread Starter  

rum
enumTableProperties(propTbl)
{Too Long!}
12 months ago
1 Reply:

Steven.G
{Too Long!}
12 months ago
Nothing New Since Your Last Visit
147
Hits

Thread 20 of 25
Thread Starter  

Allan.P
"No more files" error
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?
14 months ago
8 replies. Last post:

Steven.G
isTable and isFile force the file buffers to flush, so that makes sense.. and really can help as a warning here, if you're getting "false" returns, when you know you shouldn't be
13 months ago
Nothing New Since Your Last Visit
250
Hits

Thread 19 of 25
Thread Starter  

fullnet
ANSWER.DB and Windows 10
{Too Long!}
14 months ago
Nothing New Since Your Last Visit
156
Hits

Thread 18 of 25
Thread Starter  

rum
Table Corruption
{Too Long!}
25 months ago
4 replies. Last post:

Steven.G
{Too Long!}
25 months ago
Nothing New Since Your Last Visit
488
Hits

Thread 17 of 25
Thread Starter  

philiptdotcom
how to re-attach .Mxx files (memo fields) to a .DB
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)
29 months ago
1 Reply:

Steven.G
duplicate post.. you have to write a routine to scan the table and reinsert the files/data
29 months ago
Nothing New Since Your Last Visit
484
Hits

Thread 16 of 25
Thread Starter  

Stevron
Memo Field Accepting "Hard Return"
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
16 years ago
2 replies. Last post:

philiptdotcom
Thanks! -pt
29 months ago
Nothing New Since Your Last Visit
1876
Hits

Thread 15 of 25
Thread Starter  

ShortY406
Paradox 5 access with Java
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.
14 years ago
Nothing New Since Your Last Visit
2964
Hits

Thread 14 of 25
Thread Starter  

Pete.D2
Opening multiple tables at once
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.
34 months ago
18 replies. Last post:

Pete.D2
It's a shame these useful products like Paradox and FoxPro never got upgraded to 64 bit. They would still have their place I think.
32 months ago
Nothing New Since Your Last Visit
1314
Hits

Thread 13 of 25
Thread Starter  

Jay.M
STRINGLIST DOCUMENTATION
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.    
36 months ago
1 Reply:

Steven.G
you can check the bug list.. I never used the stringlist http://hem.bredband.net/bertilisberg/
36 months ago
Nothing New Since Your Last Visit
623
Hits

Thread 12 of 25
Thread Starter  

Bob Green
JDBC and the BDE
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.
19 years ago
Nothing New Since Your Last Visit
3419
Hits

Thread 11 of 25
Thread Starter  

riskmansea
INVALID PARAMETER ERROR
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
40 months ago
1 Reply:

Steven.G
one of the values in the table being added, isn't in a lookup table and/or doesn't meet a valcheck rule?
40 months ago
Nothing New Since Your Last Visit
620
Hits

Thread 10 of 25
Thread Starter  

PS_426
Seat number of accounting entry 1000001 is incorre
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!
40 months ago
2 replies. Last post:

Gemma.L
Ok, I undertand! thank you very much for your advice
40 months ago
Nothing New Since Your Last Visit
727
Hits

Thread 9 of 25
Thread Starter  

Klepsis
error code meaning
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?
44 months ago
8 replies. Last post:

Eugene.W
Thanks.  I'll do some research in my object pal manual and see where that takes me.  :)
44 months ago
Nothing New Since Your Last Visit
1038
Hits

Thread 8 of 25
Thread Starter  

Eugene.D2
too long file name, tables won't open
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).
7 years ago
6 replies. Last post:

Martijn.G
Sorry, it took me a while to get back to you. In the mean time, I bought a new W10 computer and re-installed P11. The problem with the tablenames has been fixed now. Unfortunately, an other problem occured. But I will look for the right thread to see if I can find an answer. Thank you for your help!
44 months ago
Nothing New Since Your Last Visit
2236
Hits

Thread 7 of 25
Thread Starter  

Jay.M
attempt unnamed file past end
{Too Long!}
44 months ago
9 replies. Last post:

Jay.M
Thanks Steve... your suggestion worked... message gone all is well!
44 months ago
Nothing New Since Your Last Visit
1020
Hits

Thread 6 of 25
Thread Starter  

Laxman.D
Table Structure export
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.
57 months ago
1 Reply:

Sam.S
I don't have a canned process for you, but you can do a fs.enumfilelist to get an array filled with table names, then enumfieldnames and enumindexstruct to get the details of the table.  then open those with a tcursor scan through the details and use a ts.writeline to write to the text file. I have done similar to document and manipulate the tables in a given directory.
57 months ago
Nothing New Since Your Last Visit
1317
Hits

Thread 5 of 25
Thread Starter  

Cottage Builder
Paradox Reports
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
59 months ago
1 Reply:

Anonymous
Just off the top of my head I think I'd design and print a form that did that rather than a report. --- Steve Caple
59 months ago
Nothing New Since Your Last Visit
1271
Hits

Thread 4 of 25
Thread Starter  

CliffSuttle
Table Repair in Version 10
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.
20 years ago
Nothing New Since Your Last Visit
4069
Hits

Thread 3 of 25
Thread Starter  

Larry.D
Private Alias Change
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
7 years ago
2 replies. Last post:

Dan
Have you tried the preferences dialog on the tools tab.  The Database tab has an option to change the location of the priv dir.
7 years ago
Nothing New Since Your Last Visit
4299
Hits

Thread 2 of 25
Thread Starter  

Cottage Builder
Paradox Development
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?
7 years ago
1 Reply:

mprestwood
{Too Long!}
7 years ago
Nothing New Since Your Last Visit
2382
Hits

Thread 1 of 25
Thread Starter  

Ben.N
.NET Control File location setting
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
7 years ago
2 replies. Last post:

Dan
More than likely you have copied the .lck files along with the tables.  Delete the .lck files in the directory containing the table and you should be good to go.
7 years ago
Nothing New Since Your Last Visit
2234
Hits

New Thread

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech