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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

Paradox Tables Topic Most Active Threads

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  

Tony.Curiale
Help with Home Network
{Too Long!}
9 years ago
18 replies. Last post:

Anonymous
Thank You Mike.  It took me a while to find it before, and a quick source is always handy.  To be honest when I needed the file I did not even think about lookiing through your resources.  Duh!  I feel a bit slow of mind when I think about it. Thanks Ralph --- Ralph Maxwell
8 years ago
Nothing New Since Your Last Visit
6038
Hits

Thread 24 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.
16 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.
14 months ago
Nothing New Since Your Last Visit
1113
Hits

Thread 23 of 25
Thread Starter  

Lemon
Encrypting paradox tables
Please, I need help. How do I encrypt paradox tables????
15 years ago
13 replies. Last post:

mprestwood
{Too Long!}
15 years ago
Nothing New Since Your Last Visit
3756
Hits

Thread 22 of 25
Thread Starter  

S0nY
longint to autoincrement? vica versa?
{Too Long!}
12 years ago
9 replies. Last post:

Dan
Sorry to have dropped out of the conversation.  I think you better do a simple proof of concept test before working with all that data.  Build a simple two field table with an autoinc and and alpha field.  Enter a couple of data records.  Restructure the table to make the autoinc a longint.  Try and convert the longint back to an autoinc.  You will not be able to convert the longint back to an autoinc.
12 years ago
Nothing New Since Your Last Visit
3067
Hits

Thread 21 of 25
Thread Starter  

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

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

Thread 20 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?
26 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.  :)
26 months ago
Nothing New Since Your Last Visit
862
Hits

Thread 19 of 25
Thread Starter  

jwhit
Temporary table resource limit
Hi I have to say I'm not much of a DB user. I play mostly in spreadsheets (QPW8 is my fav). Anyways I was assigned the task of importing a txt file with 4.1 million records. I have pumped up the BDE settings and am using the updated BDE. Thru truncating some fields I was able to get 3.8 million records out of the file before a table full error. My goal is to get as many records as possible, and then query them into a variety of smaler tables., My real problem is when I try to do anything with this table .. sort it, query it, whatever. I get a "temporary table resource limit" error. BTW, I'm using PDX 8 though that seems to matter. Ironically I also tried to import this file into Firebird SQL but it choked at around 2 million entries and it's just as finnicky. It seems large tables are taxing to just about everything. I have half a mind to try MySQL on my websirte server location but that's probably just as limited.,
10 years ago
8 replies. Last post:

greens
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
13506
Hits

Thread 18 of 25
Thread Starter  

FlaglerMuseum
Using Secondary Indexes
I have Paradox 9 and I created a database with a key.  I set up a secondary sort using the Secondary Index under Restructure Table.  Everything looks fine and I hit save but the sort does not change on the table.  My reports and forms also sort by the key, not by the Secondary Index.  I got no error messages.  Anyone have any ideas?  Thanks. 
12 years ago
8 replies. Last post:

FlaglerMuseum
Yes!!!! Thank you all so much for your help and sorry for the delay in responding, I was busy on other projects so I just got a chance to look at this again.  I see now, when in design mode I right click on the All Records band and choose Sort and that will allow me to change the sort.  Thanks again, I can now move forward (or at least attempt to) with my project  :-)  Teresa
12 years ago
Nothing New Since Your Last Visit
2547
Hits

Thread 17 of 25
Thread Starter  

marckcos
Field size help needed
I am fairly new to Paradox, I am using Version 8., My question is, how can I limit the amount of characters that a user can input on a form. I am using a DBASE IV table in Paradox. I have set the field size to 3 characters, but when I type on the form I am allowed to type up to 254 characters even though I assigned my field size to 3 characters? It gives me an error (you have exceeded the amount of characters) Is there any code that I can limit the user to only 3 characters? Can I use Picture Assistance? Please Help, , thanx
14 years ago
8 replies. Last post:

Tony.M80
OK. We won't have you flogged [b]this[/b] time.
14 years ago
Nothing New Since Your Last Visit
3004
Hits

Thread 16 of 25
Thread Starter  

Dave McCarty
Table Repair failure in Paradox 8 (and Paradox 9)
{Too Long!}
16 years ago
8 replies. Last post:

lmckelvy
One last comment. If the table is not truly version 7/8 (many created are not, since version 4 seems to be the default unless newer field types are used), you can use TUTILITY to try and do the repair.
16 years ago
Nothing New Since Your Last Visit
3900
Hits

Thread 15 of 25
Thread Starter  

FisolA
Corrupted header/index Thumbs.db
I've been  using Paradox 10 for many years and been doing some basic codings on my WIndows XP service pack 3. Lately I found errors when I wanted to evoke table look up when constructing new table. It precisely said my header/index  Thumbs.db was corrupted. "Table repair" and "table rebuild" of Thumbs.db didn't help. I did a fresh reinstallation of Paradox 10. This didn't help either. Is there a way of overcoming this problem?
11 years ago
6 replies. Last post:

FisolA
Steve. This is really a great help. Thank you. My problem is solved. It never crossed my mind that that picture files in the same folder as my paradox tables could create such havoc. Thank you again.
11 years ago
Nothing New Since Your Last Visit
4376
Hits

Thread 14 of 25
Thread Starter  

Paul Castelow
Append and Update
I am wanting to apply code to a pushbutton to Append and Update records of one table, to those of another. Can anyone help ? Cheers, Paul
9 years ago
6 replies. Last post:

1311
Many Thanks.
9 years ago
Nothing New Since Your Last Visit
2675
Hits

Thread 13 of 25
Thread Starter  

srsand
Export to text
Has anyone come across this?  I'm using Paradox 9 in Windows XP and found that if I export a table to text and choose "Use field names as first row of data",  record #1 in the table is lost from the text file.  If I don't choose "Use field names as first row of data" then record #1 remains in the text file.  The obvious solution is to add a "dummy" entry #1 on the table before the export.,
8 years ago
6 replies. Last post:

srsand
I forgot to point out that this occurs when I choose to export to ASCII Delimited txt, not ASCII fixed.
8 years ago
Nothing New Since Your Last Visit
2635
Hits

Thread 12 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).
5 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!
26 months ago
Nothing New Since Your Last Visit
1997
Hits

Thread 11 of 25
Thread Starter  

Cheesey74
Error Opening Tables on one Alias Only
We are attempting to open a table using the Project Viewer. For any table under one specific alias we get the following error message:-  'You have attempted to open a database that is in use by someone else, but the database cannot be shared.  You must set the location for the .NET control file.'  This error only appears on one specific machine.  All our other machines appear fine.  Any thoughts?   Cheers  Steve
11 years ago
5 replies. Last post:

chomp
{Too Long!}
11 years ago
Nothing New Since Your Last Visit
4636
Hits

Thread 10 of 25
Thread Starter  

ParaDelphi
VAL files
what are val files and can i delete them? im working on an older system in paradox 9 and im having table troubles with the tables and i want to delete the val files.
12 years ago
5 replies. Last post:

Paul.S
i was having trouble with a paradox application i was aksed to work on. the referential integrity was getting in my way because i did not understand what was happening. i did as you suggested and deleted the val files. fixed it up. then recreated the val files after i understood why and where they were needed. i kept a backup of the tables so i was confident i did it correct. thanks for all the help over the years.
9 years ago
Nothing New Since Your Last Visit
2973
Hits

Thread 9 of 25
Thread Starter  

Mike Prestwood
Paradox Table Repair Verify Option
I told a client of ours who is having trouble with Paradox table corruption to skip Verify and just perform a rebuild. , , Does anyone recall some of the items Verify checks on?
15 years ago
5 replies. Last post:

SUBROMAN
I have had issues with data corruption if I did not run the verify procedure before running rebuld.
15 years ago
Nothing New Since Your Last Visit
4393
Hits

Thread 8 of 25
Thread Starter  

abp
Table Corruption
We seem to have a reoccurring problem at just one of our client's offices. There are two tables (both have a key field) that have become corrupt about once a month for the past three months. We have successfully repaired the tables by using the table repair utility. Both of these tables are used heavily on a daily basis. Each time our research has shown that the time stamps of the original .db & it's .px file are out of sync. What would cause this? Our suspicions are network connectivity issues, however, how do you prove this sort of thing? We're considering removing the key field in order to eliminate the .px's but I'm not sure if that'll do the trick., , Background info: Paradox 10 application being used on Windows NT systems., , Any suggestions?
17 years ago
5 replies. Last post:

Tony.M80
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
1883
Hits

Thread 7 of 25
Thread Starter  

bphilip
Table Security
Can we implement the security on the table level in paradox,like the database or the table should be opened only through the application., , Can we sent the userid or the password using objectpal to establish a connection and maintain it until the application in closed, or establish connection when a database action in requested., , Please Help, Thanks in advance
17 years ago
4 replies. Last post:

Rick Carter
[QUOTE]I will write extra codes to block the F7 button. [/QUOTE]As mentioned, unless you have your own custom menus replacing the default ones in all cases, they can still get there from the menu. As a general principle of ObjectPAL programming, it's better to trap for any occurrence of the [i]event.[/i] Don't assume the users aren't going to find ways to get in that you wouldn't have thought of.
17 years ago
Nothing New Since Your Last Visit
1519
Hits

Thread 6 of 25
Thread Starter  

garypark
Table is read-only??????????
Hi there can someone help. I am using version 8 of paradox and I am having a problem with a newly created form. The form existed previously ans a few aesthetic changes have been made. However, when I try to run the program now I get the error message:, , "An error occured when setting the property named 'Value' of the object named 'Job_Number' of type 'Field'. The table is read-only.", , I have traced the problem to one particular section of code. This section posts a new record with a new job number which is taken from a table and incremented by one. If I comment out one line of code the form runs properly. This line is, , JOB_Number.value=currjob, , currjob is simply the value of the new job. Has anyone seen problems like this before cause this is really causing me probelms. Any help would be greatly appreciated.
17 years ago
4 replies. Last post:

garypark
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
1948
Hits

Thread 5 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.
12 years ago
Nothing New Since Your Last Visit
2859
Hits

Thread 4 of 25
Thread Starter  

techturtle
Extracting BLOB data
{Too Long!}
7 years ago
4 replies. Last post:

Jo_Lynne.L
http://pnews.thedbcommunity.com/cgi-bin/dnewsweb.exe?cmd=article&group=pnews.paradox-discussions&item=30665&utag= Hope that works. I haven't got around to it, but I need to get them out of PDX.
7 years ago
Nothing New Since Your Last Visit
3791
Hits

Thread 3 of 25
Thread Starter  

Tom.K3
Tcursors rounding number fields to 2 decimals
I have a number field in a table that stores gallons value up to 3 decimal places. I have placed a format on the field so it displays properly. When I open the table directly and look at the column and it shows the value rounded to 2 decimals however if I click in the field it will then show all 3 decimals so I know the actual value is being stored. The problem I am having is when I use a tcursor to open the table and try to get the value of that field it will only give me the rounded value and not the full 3 decimal place value. I need the full 3 decimal value so I can accurately use it for other calculations.  Help would be greatly appreciated.
6 years ago
4 replies. Last post:

Tom.K3
Thank You, that seemed to work. Tom
6 years ago
Nothing New Since Your Last Visit
2465
Hits

Thread 2 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?
18 months ago
4 replies. Last post:

Bob.S6
Good suggestion.  I'll jump over to the Delphi Group and make the same posting.
18 months ago
Nothing New Since Your Last Visit
1331
Hits

Thread 1 of 25
Thread Starter  

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

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

New Thread
Follow PrestwoodBoards on: 


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