15,897,718 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by bassofa1 (Top 10 by date)
bassofa1
27-Feb-14 5:12am
View
Because keeping the data in one table will mean that anytime we identify that a new field has to be saved, we have to change the structure by adding new column. That is not desirable if you're dealing with a database which is used by many similar clients who have slight variation in their processes. By having different types having it's own table, I only have to create a row in a reference table when a new field needs to be added. I don't know if you get what I mean.
bassofa1
26-Feb-14 11:17am
View
I thought this is detailed enough..I am just spreading the data in TableWithRecords into multiple tables based on the type of the fields - so all dates in one table, amounts in one table, texts in one table; such that to get a complete record(row) one has to look in all the tables - I have no problem with saving/retrieving the fields but just didn't want to do row by row processing; because I feel my query will be slow when I get more records to deal with.
bassofa1
26-Feb-14 9:58am
View
that is the way our schema is designed.
bassofa1
30-Oct-13 8:26am
View
Well, if it is comma-separated and you don't have control over the file then I am wondering how you can get Pen,Screw in the same column without any changes by your client. The idea of a delimited file is so that you can present data in way we can use the delimiter to get different fields- and your scenario defeats that purpose. Your answer is to get back at your client and tell him/her that they have to add an escape character where they want to use comma "," not as delimiter but as real character. For example, you can ask him to do "Pen &,Screw" representing "Pen,Screw". And then you will handle that whenever you receive a file.
bassofa1
28-Oct-13 10:38am
View
If yours is exactly as mine, then like I told you the very first time; your file is rather pipe-delimited "|" not ",". Which is the reason why you have an issue. To get "Pen,Screw" as one Column, the delimiter CANNOT be ",". Clearly it is showing "|" and that should be it.
bassofa1
28-Oct-13 6:21am
View
Ok, If I understand you clearly, there is no impact on the value that's being assigned even before the while.So in effect the underlined portion is not necessary. I think you have sufficiently answered my question. thanks.
bassofa1
28-Oct-13 6:15am
View
If I understood you clearly, you want to have Pen as separate column value and Screw as a another separate column value. As far as I am concerned, the example you posted is not even a correctly delimited record. for example I expect to see a delimiter between any two separate column values. eg.
ID | Instrument|Units | EntryDate | Comments
2C346 |pen,screw |1 |1/1/2010 |rer
confirm if your example is exactly as mine.
bassofa1
28-Oct-13 6:05am
View
Well Noted!! Thanks
bassofa1
25-Oct-13 6:19am
View
Well,I think you re-created my code and answered it your own way -I am just analyzing an existing code and have a doubt about the underlined portion of the code I posted. I just want to know if @NextGrossComm contains a value from the cursor at this point.
bassofa1
24-Oct-13 15:22pm
View
So if you look the underlined code, will you say there is data in the @NextGrossComm even before it entered the while loop?
Show More