SELECT INTO ステートメント
SELECT INTO ステートメントを使って、書式付きデータをファイルにエクスポートできます。
SQL クエリを使ったデータのエクスポート
次のクエリは、comma-separated values（CSV）ファイルフォーマットにデータをエクスポートします。
C#
String connectionString = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;";
using (Sage50UKConnection connection = new Sage50UKConnection(connectionString)) {
Sage50UKCommand cmd = new Sage50UKCommand("SELECT TradingAccountUUID, Name INTO [csv://TradingAccounts.txt] FROM [TradingAccounts] WHERE TradingAccountUUID = 'c2ef66a5-a545-413b-9312-79a53caadbc4' ", connection);
int rowsAffected = cmd.ExecuteNonQuery();
}
VB.NET
Dim connectionString As [String] = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;"
Using connection As New Sage50UKConnection(connectionString)
Dim cmd As New Sage50UKCommand("SELECT TradingAccountUUID, Name INTO [csv://TradingAccounts.txt] FROM [TradingAccounts] WHERE TradingAccountUUID = 'c2ef66a5-a545-413b-9312-79a53caadbc4'", connection)
Dim rowsAffected As Integer = cmd.ExecuteNonQuery()
End Using
URI で他のファイルフォーマットを指定できます。以下の例は、tab-separated values（TSV）にエクスポートします。
C#
String connectionString = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;";
using (Sage50UKConnection connection = new Sage50UKConnection(connectionString)) {
Sage50UKCommand cmd = new Sage50UKCommand("SELECT * INTO [TradingAccounts] IN [csv://filename=c:/TradingAccounts.csv;delimiter=tab] FROM [TradingAccounts] WHERE TradingAccountUUID = 'c2ef66a5-a545-413b-9312-79a53caadbc4'", connection);
int rowsAffected = cmd.ExecuteNonQuery();
}
VB.NET
Dim connectionString As [String] = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;"
Using connection As New Sage50UKConnection(connectionString)
Dim cmd As New Sage50UKCommand("SELECT * INTO [TradingAccounts] IN [csv://filename=c:/TradingAccounts.csv;delimiter=tab] FROM [TradingAccounts] WHERE TradingAccountUUID = 'c2ef66a5-a545-413b-9312-79a53caadbc4'", connection)
Dim rowsAffected As Integer = cmd.ExecuteNonQuery()
End Using