Book a Demo

Author Topic: Controlling generated SQL  (Read 3485 times)

libertytrooper

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Controlling generated SQL
« on: September 20, 2015, 05:48:47 am »
I added an SQLite Database Product.
I've imported the tables and am viewing them in the Database Builder. When selecting the 'View Top 100 Rows' of the context menu on a table:
    it generates SQL with quoted column names.  
    This results in 100 rows of column names.  

How do I control the generation of the SQL for SQLite so that it doesn't quote the column names

An abbreviated sample of the generated sql is


<code>

Select  'fldRecID'
            , 'fldSubject'
            , 'fldNote'
            , 'fldStartDate'
            , 'fldStartTime'
            , 'fldEndDate'
            , 'fldEndTime'
            , 'fldAllDay'
            , 'fldColor'
            , 'fldReminder'
            , 'fldReminderTime'
            , 'fldTypeID'
            , 'fldStatusID'
            , 'fldLocation'
            , 'fldUrl'
            , 'fldMeetingEvaluation'
            , 'fldMeetingGoalsAccomplished'
            , 'fldRepeat'
            , 'fldFrequencyOccurence'
            , 'fldEveryOccurence'
            , 'fldEveryWeekly'
            , 'fldEveryDays'
            , 'fldOnTheOrderWeek'
            , 'fldOnTheMonthWeekDay'
            , 'fldEveryYearMonth'
            , 'fldOnTheOrderYear'
            , 'fldOnTheYearWeekDay'
            , 'fldRepeatEnd'
 From 'tblAppointment' LIMIT 100

</code>