Database

What about [MS Visual FoxPro ODBC driver](https://docs.microsoft.com/en-us/sql/odbc/microsoft/visual-foxpro-odbc-driver?view=sql-server-2017)?

Glad I could be of assistance; and I guess I don't need to push in the other code sample Director of Transmogrification Services Shinobi of Query Language Master of Yoda Conditional

You got me thinking now. I'll continue using Mongo and try to come up with a solid compact design. Thanks! If it ain't broke don't fix it Discover my world at jkirkerx.com

I've just answered it in CG Forum. Choose something from [Google](https://www.google.com/search?newwindow=1&ei=q8JoXdqUIMSMkgX1qYy4AQ&q=jro+compactdatabase+c%23&oq=jro+compactdatabase+c%23&gs\_l=psy-ab.3...186859.198379..200583...0.1..0.98.477.7......0....1..gws-wiz.......0i71j0i7i10i30j0i30j0i10i30j0i7i30j0i22i30j0i22i10i30.ekOjV4KlwA8&ved=0ahUKEwialrej\_KnkAhVEhqQKHfUUAxcQ4dUDCAo&uact=5)

That doesn't fix our in-house DB version conflicts. :) BTW, I misspoke - dev is 2012, test is 2008r2, and prod/pre-prod are 2016. So it's even worse than I initially indicated. I complained to the DBAs, and they just shrugged their shoulders... ".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

That did it!! Ya know I stared at this for an hour. I'm an idiot. Thanks! If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

SQL server database 824 error means that the page has been read successfully from the disk but there is some issue with the page. Other types of messages that might be shown are “fatal error 824 occurred” , “SQL server detected logical consistency based i/o error”. The exact display message can be more helpful in understanding this problem.

1. Data Product Architectures Benjamin Bengfort @bbengfort District Data Labs 2. Abstract 3. What is data science? Or what is the goal of data science? Or why do they pay us so much? 4. Two Objectives Orient Data Science to Users 5. Data Products are self-adapting, broadly applicable software-based engines that derive their value from data and generate more data by influencing human behavior or by making inferences or predictions upon new data. 6. Data Products are Applications that Employ Many Machine Learning Models 7. Data Report 8. Without Feedback Models are Disconnected They cannot adapt, tune, or react. 9. Data Products aren’t single models So how do we architect data products? 10. The Lambda Architecture 11. Three Case Studies 12. Analyst Architecture 13. Analyst Architecture: Document Review 14. Analyst Architecture: Triggers 15. Recommender Architecture 16. Recommender: Annotation Service 17. Partisan Discourse Architecture 18. Partisan Discourse: Adding Documents 19. Partisan Discourse: Documents 20. Partisan Discourse: User Specific Models 21. Commonalities? 22. Microservices Architecture: Smart Endpoints, Dumb Pipe HTTP HTTP HTTP HTTP HTTPHTTP HTTP Stateful Services Database Backed Services 23. Django Application Model 24. Class Based, Definitional Programming from rest_framework import viewsets class InstanceViewSet(viewsets.ModelViewSet): queryset = Instance.objects.all() serializer_class = InstanceSerializer def list(self, request): pass def create(self, request): pass def retrieve(self, request, pk=None): pass def update(self, request, pk=None): pass def destroy(self, request, pk=None): pass from django.db import models from rest_framework import serializers as rf class InstanceSerializer(rf.ModelSerializer): prediction = rf.CharField(read_only=True) class Meta: model = Instance fields = ('color', 'shape', 'amount') class Instance(models.Model): SHAPES = ('square', 'triangle', 'circle') color = models.CharField(default='red') shape = models.CharField(choices=SHAPES) amount = models.IntegerField() 25. Features and Instances as Star Schema 26. REST API Feature Interaction 27. Model (ML) Build Process: Export Instance Table COPY ( SELECT instances.* FROM instances JOIN feature on feature.id = instance.id ... ORDER BY instance.created LIMIT 10000 ) as instances TO '/tmp/instances.csv' DELIMITER ',' CSV HEADER; 28. Model (ML) Build Process: Build Model import pandas as pd from sklearn.svm import SVC from sklearn.cross_validation import KFold # Load Data data = pd.read_csv('/tm

SqlParameter Class (System.Data.SqlClient) | Microsoft Docs[^] Date and Time Data Types and Functions (Transact-SQL) - SQL Server | Microsoft Docs[^]

So long as the VPN's connected, it should be the same as accessing a server on the same network. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Let's discuss this in a bit proper detail with the application of performance, security and regulations. You can store anything that is publicly available on your website, and does not contain any personal or identifying information in a cookie. The reason for this is, that a user might be accessing your website from a public machine or PC and that data might be tracked or stored. Next, for a session you can use this storage to store any information that might identify (because, hey, that is what a session is about, right?) the user and help your website perform an operation quickly—without having to query the database again just to find out their user id, or email address. Do remember that on most frameworks (if not all), session data is sent to the client too. Now as per regulations, make sure you are requesting permissions from the users to store the cookies on their machines—European regulations require you do that, and then there is GDPR, and etc. etc. Now as for the database part, this space is expensive and filling it with the content that does not help you in anyway—let us for a moment ignore the analytics, user studies, machine learning for recommender systems, etc.—and they will only take away the space that you should pay for the content that helps you generate some business profits. What I would recommend here is, store the cart information in the cookies, just reference the URLs of the items they want to purchase. This way, the cart information will be stored locally. This will decrease the overall load on your web servers, and will not cause extra charges in the database storage as well since your users will be storing their interests locally and won't add a cart option in database, and forget it leaving there forever. One tip I can provide here is to use localStorage APIs, instead of cookies, because cookies also have a round trip from and back to server, adding an overhead on the HTTP request. [Window.localStorage - Web APIs | MDN](https://developer.mozilla.org/en-US/docs/Web/API/Window/localStorage) In this approach, of course you will end up showing what John wanted to purchase to Johanna as well, and that can be fixed by storing the session id(! Remember, store only the session id not the user id and then verify that the sessions are same for the user—which can be done by some backend algorithm to check if user ids of the sessions are the same :laugh:) The shit I complain abou

Depending on how dynamic the table is (I would think Ports would be rather static) I would brute force the categories into separate table(s) and either use Richards pivot or a monstrous view with 30 left outer joins. Then when you get a new Ports just run the brute again to parse the Categories. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Thank you both. I looked at the links and they will help a lot. I think I trying to make it harder than it needs to be..I guess that is the engineer in me. :-D

Slightly you say... :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: It's been years since the last time I designed a database and it was at school, so well... I preferred to ask for advice here before... Thank you for checking it! :cool::thumbsup:

CHill60 wrote: It's nice until you end up with two customers with the same name! :laugh: You, like the computer, and the cashier, need to be able to distinguish between the two, even in a listview. Wouldn't want to bill the father for the son's purchases :) CHill60 wrote: So we have autonumbers - the onboarding process does the necessary checks for duplication :laugh: Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.