I.T. Discussion Community!
Highlights Updated Posts Unanswered Posts Online Today Who's Reading What Member Birthdays!

HighLights (Paradox Group)

Switch to New Group Posts By Type view.

New: Paradox Group Members

1. PS_751  (3 visits. Chicago, IL USA) 2. PS_2355  (1 visits. Rome, -- IT) 3. Martin.T2  (8 visits. Phoenix, -- --) 4. SamSpade  (10 visits., -- --) 5. clivegrn  (1 visits. New Yrok, -- --) 6. cybx  (68 visits. southlake, TX USA) 7. Andrew.G  (6 visits., -- --) 8. SteveM  (3 visits. San Diego, CA USA) 9. PS_1948  (1 visits. Colne, -- --) 10. PS_1789  (5 visits., -- --)

New Paradox Posts: All Types

New?   Title Created By For...
None. No highlights in last 90 days.
Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New: Paradox Message Board Posts

Go To: Paradox Message Board

Thread 5 of 5
Thread Starter  

Connecting to PostgresSQL server
Hi,  I have been dragged back from retirement to fix a small Paradox database we use for design. Previously I used the Paradox ODBC to connect to the DB and all was well. The DB is now a PostgreSQL databse. I have installed the ODBC connection and can connect useing Access.  PostgreSQL35W ODBC System DSN On the paradox form I have a button to connect to the DB useing the following Code dynalias["UserName"] = "aaaaa", dynalias["Password"] = "XXXXXX" if not db.open(":PostgreSQL35W:", dynalias) then   ;Which Is the ODBC System DSN, , msginfo("Caliach Database Not Open", "stop") else message.visible = true ;UPDATE NEW PARTS, message = ("UPDATING PARTS DATA") sqlvar = sql SELECT PTMPTNO, PTMP1CD, PTMSTUM, PTMSEQ,PTMSATX , PTMUSE1, PTMUSE2, FROM altro.PTMFILE altro_ptmfile, WHERE PTMSEQ > ~oldptmseq, endsql executeSql(db, sqlvar, ":caliachData:NewParts"), , endif How do I change this to connect to the Postsgres35 DYN?
Posted to MB Topic: QBE & SQL
6 days ago
1 Reply:

> ":PostgreSQL35W:" are you certain that the alias itself is correctly defined in the BDE and/or the app? > msginfo("Caliach Database Not Open", "stop") throw in an errorshow(), too.. might answer the question
5 days ago
Nothing New Since Your Last Visit

Thread 4 of 5
Thread Starter  

Print form without user interaction
I would like to print the current form from a button. This can be done in objectPal by performing postaction(DataPrint) or action(DataPrint) When the postaction(or action) is performed, the printer dialog box pops up. I would like to perform this print action without the user having to click the Print button on the printer dialog box. I have tried using sendKeys with different options. Do you know of a way to print a form without any further using interaction other than clicking the button I have added on the form? Thanks
Posted to MB Topic: Paradox Forms
7 days ago
1 Reply:

action(DataPrint) is the app equivalent for "File/Print" or hitting Ctrl-P I'm pretty sure there's a "current record capture" option buried in there somewhere, but can't think of it offhand
5 days ago
Nothing New Since Your Last Visit

Thread 3 of 5
Thread Starter  

I‘ve taken libraries that were originally made in previous versions of paradox. I have successfully resaved them under paradox 9 with no syntax errors. Then I deliver them. Problem is when I try to reference the delivered library vs the source, I get an error that this file doesn‘t have any symbol table information. Anybody know why?
Posted to MB Topic: ObjectPAL
21 days ago
20 replies. Last post:

I read somewhere that paradox puts the command into some sort of queue and makes you think it worked. I finally got it to work. It must be the very last line of code before endmethod. Not even an endif statement can be after it. Supposedly you can leave a form open by trapping for an eventID. I haven't tried that yet. This particular thing I was working on was just a script. Didn't used to be so touchie. 
20 days ago
Nothing New Since Your Last Visit

Thread 2 of 5
Thread Starter  

Hiding the desktop
I read a short article that says in order to not see the desktop, and only my forms, I need to use app.hide() The problem is that when I try it, I get syntax errors.  I've searched through the boards and through the ObjectPal guide that I have, but I have not been able to find out exactly how to do this (what code and where) I also cannot seem to find where in the Object Explorer it is indicated whether a form is a child or a dialog.  I know this seems simple, but its very frustrating.  Thank you for your help.
Posted to MB Topic: Paradox Forms
8 months ago
Nothing New Since Your Last Visit

Thread 1 of 5
Thread Starter  

How to use ObjectPAL to define Lookup Table?
Is there any way to specify Table Lookup settings when using the Table type to create a new table? I've thouroughly searched the PAL help, and then resorted to trying to use sendKeys after creating the temporary table I need, but nothing works. {#confused} (I have had little success and many problems with sendKeys since upgrading to version 9.) If necessary, I will just use an interactively created table and copy it to each machine, but it would be much better to avoid this since the table is of temporary nature., , Thank you!
Posted to MB Topic: ObjectPAL
19 years ago
Nothing New Since Your Last Visit

New: Paradox Knowledge Base Posts

Go To: Paradox Knowledge Base
  KB Article    

1. A Customized Software Glitch That Was Not

This article discusses what seemed to initially be a Corel Paradox programming glitch in objectPAL language that was actually something completely different.

Posted to KB Topic: ObjectPAL Coding
23 months ago
(5 Comments , last by cred.f )

Nothing New Since Your Last Visit

John Andres
2. open table
Posted to KB Topic: P9 Book: Power Programming
26 months ago
(6 Comments , last by Pervez.J )

Nothing New Since Your Last Visit

3. How to Make Programmed Paradox Queries with Microsoft Notepad

Takeaway: This article discusses a technique I use to create ObjectPAL queries that can easily be modified for other purposes such as customized reporting.

Posted to KB Topic: ObjectPAL Coding
6 years ago, and updated 24 months ago
(3 Comments , last by mprestwood )

Nothing New Since Your Last Visit

4. Paradox ObjectPAL Email Blast Programming

This article will discuss an ObjectPAL coding technique I use to send out an “email blast” from a Paradox data table of email addresses via a third party email client.

Posted to KB Topic: ObjectPAL Coding
6 years ago, and updated 24 months ago

Nothing New Since Your Last Visit

New: To/From Code

Go To: Paradox To/From Guides

Code Snippets

  Code Snippet Created
1. Array 3/23/2010
2. Sort Records 2/8/2010
3. Filter Records 2/7/2010
4. Find Record 2/7/2010
5. Edit Record 2/7/2010
6. Record Movement 2/7/2010
7. Comments 1/1/2009
8. subStr 1/1/2009
9. End of Statement 1/1/2009
10. Case Sensitivity 1/1/2009


  Topic Category Created
1. Array Data Structures 3/20/2010
2. Sort Records Database 2/8/2010
3. Filter Records Database 2/7/2010
4. Find Record Database 2/7/2010
5. Edit Record Database 2/7/2010
6. Record Movement Database 2/7/2010
7. Comments Language Basics 1/1/2009
8. Left of String Commands 1/1/2009
9. Prevent Derivation OOP Details 1/1/2009
10. Abstraction OOP Details 1/1/2009

New: eCertified Study Questions

Go To: eCertified
Question Level Type Based on KB Post KB Topic
{Too Long!} 2 TF {Too Long!} Paradox & ObjectPAL
{Too Long!} 3 MC {Too Long!} OPAL: Language Basics
What are the logical operators? 1 MC {Too Long!} OPAL: Language Basics
{Too Long!} 1 MC ObjectPAL Assignment (=) OPAL: Language Basics
{Too Long!} 2 TF {Too Long!} OPAL: Language Basics
Which statement is true? 2 MC {Too Long!} OPAL: Language Details
{Too Long!} 1 MC {Too Long!} OPAL: Language Basics
{Too Long!} 2 TF {Too Long!} OPAL: Language Basics
{Too Long!} 1 MC {Too Long!} OPAL: Language Basics
{Too Long!} 1 YN {Too Long!} OPAL: Language Basics

Switch group?

  • AmericanIT HighLights
  • Industry HighLights
  • Linux HighLights
  • Owners HighLights
  • PrestwoodBoards HighLights
  • Windows HighLights
  • IT Professionals:
  • Analyst HighLights
  • Coder HighLights
  • DBA HighLights
  • Proj Man HighLights
  • Tech HighLights
  • Tech Writer HighLights
  • Tester HighLights
  • Desktop Databases:
  • Access HighLights
  • Paradox HighLights
  • V.FoxPro HighLights
  • Website Scripting:
  • ASP Classic HighLights
  • Design HighLights
  • JavaScript HighLights
  • Perl HighLights
  • PHP HighLights
  • General Dev Tools:
  • C# HighLights
  • C++ HighLights
  • Delphi HighLights
  • Java HighLights
  • Prism HighLights
  • VB Classic HighLights
  • VB.Net HighLights

  • Follow PrestwoodBoards on: 

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