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 BoardParadox Runtime & Distribution Topic   Print This     

Script not available in Runtime

Script not available in Runtime in Paradox Runtime & Distribution topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: available   Runtime   Script not   Script not available  
Paul Castelow
Ashburton, New Zealand
Using PDX Expert I have written the following script, but when used in Runtime the message says "Function not available in runtime version"
Can anyone help or I would even prefer on a Button.
method run(var eventInfo Event)
var
dtHandle DataTransfer ;// handle to transfer variable

tvTable TableView ;// tmp handle for displaying imported file
endVar

;// Set notification for user
setMouseShape(MOUSEWAIT, TRUE)

dtHandle.setSource("CallInsert.txt", dtASCIIVar)
dtHandle.setSourceCharSet(dtANSI)

;// Enable the key violation and problems tables
;//
dtHandle.setKeyViol(TRUE)
dtHandle.setProblems(TRUE)

;// Setup delimited import options
;//
dtHandle.setSourceSeparator(",")
dtHandle.setSourceDelimiter("\"")
dtHandle.setSourceDelimitedFields(dtDELIMALLFIELDS)

;// We are always appending in this script since we force the
;// destination table to always exist
;//
dtHandle.setDest("Call.DB")
dtHandle.setAppend(TRUE)

;// Perform the import
;//
dtHandle.transferData()

;// Reset cursor for the user
;//
setMouseShape(MOUSEARROW, TRUE)

;// Display table
;//
tvTable.open("Call.DB")

endMethod
Many Thanks, Paul (PC)
 Posted 13 years ago (Thread Starter)
Comment Quote
About Paul Castelow -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11417, 7 replies
Thread Started 2/20/2006 9:27:00 PM
View Counter=3263
Last Reply Posted 2/22/2006 5:31:00 PM)
Location=Ashburton, New Zealand  
Joined=18 years ago   MB Posts=128  
Paul Castelow
Ashburton, New Zealand
Hi Steve, I notice from its file properties that CallInsert is MS Schedule+. (Generated ?)
also the debug stopped at
setMouseShape(MOUSEWAIT, TRUE)
Thanks for your help,
PC
 Posted 13 years ago (Thread Starter)
Comment Quote
About Paul Castelow -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11419 (Level 1.1)  Reply to 11417
Thread Started 2/21/2006 11:12:00 AM
View Counter=2
Location=Ashburton, New Zealand  
Joined=18 years ago   MB Posts=128  
Paul Castelow
Ashburton, New Zealand
Should have made the point that works fine in Paradox but not in Runtime
 Posted 13 years ago (Thread Starter)
Comment Quote
About Paul Castelow -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11420 (Level 1.2)  Reply to 11417
Reply Posted 2/21/2006 11:17:00 AM
Location=Ashburton, New Zealand  
Joined=18 years ago   MB Posts=128  
Paul Castelow
Ashburton, New Zealand
Hi Steve, where does the first code go?
 Posted 13 years ago (Thread Starter)
Comment Quote
About Paul Castelow -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11422 (Level 1.3)  Reply to 11417
Reply Posted 2/22/2006 12:03:00 PM
Location=Ashburton, New Zealand  
Joined=18 years ago   MB Posts=128  
Steve Caple
Steve Caple Company
Sacramento, CA
> Using PDX Expert I have written the following script, but when used in Runtime the message says "Function not available in runtime version"

Have you stepped through it in debug to see which function triggers that error? Is it opening the tableView?

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 13 years ago
Comment Quote
About Steve Caple -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11418 (Level 1.4)  Reply to 11417
Reply Posted 2/20/2006 11:20:00 PM
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  
Steve Caple
Steve Caple Company
Sacramento, CA
> Should have made the point that works fine in Paradox but not in Runtime

As I should have made clear that Runtime doesn't support tableView; you can provide a simple form with a tableFrame; you can even use a form with a generic tableFrame with both horizontal and vertical scrollbars, and set the tableFrame's tabeName property before making it visible:
method CallMaintForm(stTitle string, stTable string) logical
var
f form
endvar
if not f.open(":FORMS:MaintTF",WinStyleHidden) then
return FALSE
endif
f.setTitle(stTitle)
f.MaintTF.tableName = stTable
f.bringToTop()
f.wait()
f.close()
return TRUE

endMethod
It's not pretty, but not a lot more ugly than a tableView, either. I would make this a dialog form, modal, with a title bar but no control menu, minimize or maximize buttons, and an OK button to do a formReturn().

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 13 years ago
Comment Quote
About Steve Caple -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11421 (Level 1.5)  Reply to 11417
Reply Posted 2/22/2006 10:01:00 AM
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  
Steve Caple
Steve Caple Company
Sacramento, CA

Originally posted by Paul Castelow:

Hi Steve, where does the first code go?


Uh, er, hunh? I'm not sure what you mean by "the first code"; the method example I showed could be in a library or on a form, and could be used to present a table in a tableView like presentation without running afould of Runtime limitations. Of course you may well want to choose different method and form names.

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 13 years ago
Comment Quote
About Steve Caple -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11423 (Level 1.6)  Reply to 11417
Reply Posted 2/22/2006 5:30:00 PM
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  
Most Recent Post
Steve Caple
Steve Caple Company
Sacramento, CA

Originally posted by Paul Castelow:

Hi Steve, where does the first code go?


Uh, er, hunh? I'm not sure what you mean by "the first code"; the method example I showed could be in a library or on a form, and could be used to present a table in a tableView like presentation without running afould of Runtime limitations. Of course you may well want to choose different method and form names.

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 13 years ago
Comment Quote
About Steve Caple -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11424 (Level 1.7)  Reply to 11417
Reply Posted 2/22/2006 5:31:00 PM
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1251A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #11417 Counter
3263
Since 4/2/2008
Follow PrestwoodBoards on: 


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