Re: [sqlite] Dates based on fliter

My understanding on the below code is that this is adding one month to the current date. I need to add months to the date listed in a table. Simon Slavin-3 wrote: > > > On 28 Oct 2010, at 7:58pm, Redhot wrote: > >> the first filter would be the Date entered to >>

[sqlite] Dates based on fliter

I would like to add the 6 months, 12 months 18 months and 24 months to a date entered into the sqlite database. The date in the database is in sql formate -MM-DD. The dates will be used for a filter. The filter will pull Rows from a table. Like the first filter would be the Date entered to

[sqlite] create View for four tables

I need to pull information from 4 different tables. I read taht using the "Create View" is that best way for this. Can you let me now if my code is correct? CREATE TEMP VIEW TEBASdb.TwoYrExceptvw as SELECT tblinfoDataSheet.Issue_Price , tblinfoDataSheet.O_I_PremDisc ,

[sqlite] Date range based on Date in different table

I would like select a date range (from/To) from a date database selection. The user enters a date (ProcessDate) in the database. ProcessDate is stored in table (tblData). I would like to get from another table (TblFund) the Rows that match the data criteria based on Date (ProcessDate)entered in

[sqlite] creating a report from four tables

I'm a newbie to sqlite and programmig. I have creae a sqlite databse. I would like to ceate reports from the database. I would like to create a Report from the database that is create by more than one table from the database. Code: dim dr as new DatabaseRecord // Build the SQL