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

May 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 6 years ago (Thread Starter)
Comment Quote
About Alex.V -Collapse +Expand
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=1744
Location=Mayaguez, PR PR 
Joined=6 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 = P1246A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15018 Counter
1744
Since 4/2/2013
Follow PrestwoodBoards on: 


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