I'm trying to use UpdateDatabase to be able to insert my data into the UploadFileRevision table in the database without success.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/4a8897c7-e1c3-41dc-8c74-d3c79a31f65f.png)
I don't know how to do the above request. ?
I'm trying to use UpdateDatabase to be able to insert my data into the UploadFileRevision table in the database without success.
I don't know how to do the above request. ?
Among other possibilities, I believe you need to update the record after setting the values and before persisting.
revisionMaint.Document.Update(isertIcon);
revisionMaint.Persist();
Alternatively, you could probably do something like this:
revisionMaint.Document.Insert(new UploadFileRevision
{
FileID = "the ID",
// other properties
IsDrawingLogCurrentFile = null
});
revisionMaint.Persist();
This should work because all the data is being inserted at once.
As for the errors, the graph you need to reference is UploadFileMaint, not UploadFileRevisionMaint, and it lives in the PX.SM library.
You’ll need to include
using PX.SM;
at the top of the page.
Among other possibilities, I believe you need to update the record after setting the values and before persisting.
revisionMaint.Document.Update(isertIcon);
revisionMaint.Persist();
Alternatively, you could probably do something like this:
revisionMaint.Document.Insert(new UploadFileRevision
{
FileID = "the ID",
// other properties
IsDrawingLogCurrentFile = null
});
revisionMaint.Persist();
This should work because all the data is being inserted at once.
As for the errors, the graph you need to reference is UploadFileMaint, not UploadFileRevisionMaint, and it lives in the PX.SM library.
You’ll need to include
using PX.SM;
at the top of the page.
the missing error image is importing the "Using PX.SM" library;
this is the answer
Hi
Here is that ustomization package
Among other possibilities, I believe you need to update the record after setting the values and before persisting.
revisionMaint.Document.Update(isertIcon);
revisionMaint.Persist();
Alternatively, you could probably do something like this:
revisionMaint.Document.Insert(new UploadFileRevision
{
FileID = "the ID",
// other properties
IsDrawingLogCurrentFile = null
});
revisionMaint.Persist();
This should work because all the data is being inserted at once.
As for the errors, the graph you need to reference is UploadFileMaint, not UploadFileRevisionMaint, and it lives in the PX.SM library.
You’ll need to include
using PX.SM;
at the top of the page.
I tried this solution but still got the error.
Sorry, UploadFileMaintenance
I tried and it seems UploadFileMaintenance does not contain Document
I've tried the same way with no success
I wasn’t giving you working code. I was making you aware of the conventions and best practices that Acumatica uses. I assumed the basics of the code you had was mostly correct already.
I can’t speak for all the developers here, but I’m not here to write customizations for free. I have limited time in a day, and I pay bills like everyone else. Generally, I’m guessing most are here helping people because they remember what it’s like to start out kinda lost.
On that, note, in Visual Studio, here is the list of likely candidates for the main view:
I’d put my money on ‘Files’.
Turns out it’s kinda difficult to tell from the UI where files actually go.
I wasn’t giving you working code. I was making you aware of the conventions and best practices that Acumatica uses. I assumed the basics of the code you had was mostly correct already.
I can’t speak for all the developers here, but I’m not here to write customizations for free. I have limited time in a day, and I pay bills like everyone else. Generally, I’m guessing most are here helping people because they remember what it’s like to start out kinda lost.
On that, note, in Visual Studio, here is the list of likely candidates for the main view:
I’d put my money on ‘Files’.
Turns out it’s kinda difficult to tell from the UI where files actually go.
Thanks for your help. ♡♡♡
I have solved my problem.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.