Devart Forums

When the server already has the same file name and it is incomplete and needs to be appended, the 3rd parameter of UploadFile is set to false and the upload file will have an error, the file size is fine but the first half of the file is set to 0 and the appended content is placed at the end of the file.

After tracing the code, the code in the TScSFTPClient.OpenAndUploadFile function OpenModes := [foWrite, foCreate, foExcl]; needs to be changed to OpenModes := [foWrite, foCreate, foAppend]; to be able to properly Append the file.

TScFTPClient was uploading files of 0 bytes after setting UseCompression to True.
After reviewing the source code, the problem can be solved by modifying the TScFTPClient.OnWriteData function as follows
procedure TScFTPClient.OnWriteData(Stream: TStream; const Data: TBytes; Count: integer);
begin
// FDataConnection.Write(TValueArr(Buffer), 0, Count);// This is the original code
FDataConnection.Write(TValueArr(Data), 0, Count);
DoProgress(FTotalUploadSize, FTotalUploadSize - (Stream.Size - Stream.Position));
end;

In addition, VirtualTable1-> Assign (ADOQuery1); often 'Out of Memory'

System: Windows2003 3G Memory

Sorry, not this field, and is a Guid, SQL Server in NewID (), XML for type = 'uuid'

I am sorry, I am wrong, there is this method, but this method to generate the XML file, VirtualTable not re-loaded, loading tips: Data type is not supported.

Sorry, I think this method does not provide TVirtualTable

My English is not very good, but others do not have this problem?
I am now using C + + Builder, where has also tried in Delphi, but also have this problem.

/*
--SQL 2000 or SQL 2005 or SQL 2008
Create table test
(
column1 numeric(14,4)
)
insert into test values(14.55)
*/
TMemoryStream *ms=new TMemoryStream();
ADOQuery1->SQL->Add("select * from test");
ADOQuery1->Open();
VirtualTable1->Assign(ADOQuery1);
VirtualTable1->SaveToStream(ms); <---Unknown data type FieldDesc.DataType=27


//I Use VirtualTable 6.90 for RAD Studio 2010