I want to export a txt file in the exact form of a localization file. I.e. no field header, no quotes limiting text and file extension 'txt' The TXT datasource in Manifold doesnt allow INSERT without mfd_id identifier. This is not doing exactly what I want although it uses a PropertySet as it works for import. Is there a solution in pure SQL or should I go with VB.NET? ' VB.NET ' Manifold 9.0.169 Class Script Shared Manifold As Manifold.Context Shared Sub export_ui_file(tableName as String, path AS String) Dim app AS Manifold.Application = Manifold.Application Dim db AS Manifold.Database = app.GetDatabaseRoot() Dim connProperties = app.CreatePropertySet() connProperties.SetProperty("Source", path) connProperties.SetProperty("SourceDelimiter", "\t") connProperties.SetProperty("SourceFieldHeader", false) connProperties.SetProperty("SourceQuote", "") db.Export(tableName , "csv", connProperties.ToJson()) app.Log(connProperties.ToJson()) End Sub Shared Sub Main() export_ui_file("_temp_ui_Tbl", "E:\Temp\ui.de.txt") End Sub End Class
Do you really want to ruin economy only to save the planet? |