Hi there, i tried for a lot of time to do a project for my college but for me it sounds fkin impossible since i have to combine C++ with Access and do some stupid things, i tried finding tutorials around here and across the internet and i couldn't do a damn thing.
The problem sounds like this: You must do the scan of some tables one by one. To scan every column with every column, skipping the unknown keys, and the booleans. For every numeric column and calendar date i must verify if it exists a domain constraint associated or not. For type text(short text) columns i must calculate whatțs the length in instant of the data base for those strings, to see if the next multiple of 2 este smaller than the max length declared and if it's yes, wwe must propose to user the possibility to restrict the max length to that ( lengthmax=255, the biggest string is 18, the user would want to restrict to 2^5(32) ). Any other system-dependent data types are ignored.
The "some stupid things" are utterly trivial, and similar to:
* For each value in array A, do check if array B has that value
* Find maximum value from array
I do hope that that part is not the impossible.
Trivial homework reads data from standard input.
The next level reads data from file.
You have data in a file that is in Access format.
You can't/shouldn't attempt to read such file directly.
Access must provide some API, i.e. libraries/functions that you can call in C++ code. Word "ODBC" might relate to that.
If you have been given a project that includes Access, then surely the use of Access has been shown before that?
Not just on Windows. Qt framework has SQL module that (presumably) supports multiple platforms. Besides, I'm quite sure I've set up odbc on Linux for some (third party) application.
oh thank you for your answers. they haven't gave me any fkin hints also i haven't made c++ for a while(3-4 years)
He doesn't want to answer my questions he only told me good luck. :/ That's the mentality in romania of our teachers.
Sorry to hear that, but it's not only in Romania.
Seems that many "teachers" nowadays only want to give assignments and grade them, but are not interested in teaching. :-(