-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Binary data is not stored in the MS SQL Database

Binary data is not stored in the MS SQL Database in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Database   Binary data   Binary data not   stored MS   SQL Database  
Most Recent Post
Alex.V
CIQA
Mayaguez, PR PR

I'm trying to upload files to a SQL Server database with ObjectPAL but the binary data not being stored in the SQL Server database but in with Paradox  table this code works fine. I think that MS SQL is not recognizing the data for some reason. 

objectPal variable is binary and MSSQL field is varbinary(MAX)

 

............

fileDataBinary             ;Save file data 

endVar

.............

if fileData.readFromFile(selectedFile) then 

..........

TC_Attachments.edit()

TC_Attachments.insertRecord()

TC_Attachments.Social_Security_No  = "AXVD20"

TC_Attachments.File_Name_Native= fileName 

TC_Attachments.File_Size_Native = fileData.size() ;Store size in bytes

TC_Attachments.File_Attachment_Native = fileData           ;Store data in binary

TC_Attachments.Upload_Date   = datetime()

TC_Attachments.endEdit()

 Posted 12 years ago (Thread Starter)
Comment Quote
About Alex.V
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #15018, No Replies Be the first!
Thread Started 4/2/2013 9:17:34 AM
View Counter=2456
Location=Mayaguez, PR PR 
Joined=12 years ago   MB Posts=2  

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 = P1102A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15018 Counter
2456
Since 4/2/2013
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2025 Prestwood IT Solutions.   [Security & Privacy]