Topic: Phone book database

The Phone Book allows you to store basic contact information.


Download:
http://myvisualdatabase.com/database_ex … nebook.zip


Screenshots:
http://myvisualdatabase.com/database_examples/phonebook1.png

http://myvisualdatabase.com/database_examples/phonebook2.png

http://myvisualdatabase.com/database_examples/phonebook3.png

http://myvisualdatabase.com/database_examples/phonebook4.jpg

Dmitry.

Re: Phone book database

I am new to MVD.  When testing this sample phonebook application, I receive a SQL Syntax error if the last name entered in the textbox contains an apostrophe in a record being added (SQL INSERT).  MVD does not seem to generate this error if an apostrophe is added prior to a record update. 

I can also see from other forum posts that this topic has been discussed but I do not understand the preferred method for handling this common situation.  Should one always use custom script (SQL Insert) for any textbox linked to a database field?  Or... should one use a custom script to process the textbox before a MVD Saverecord?  And if it is the second option, what string functions are available in MVD from the SysUtils Unit?  "StringReplace" ??

Thank you.

Re: Phone book database

tbo
It's just bug of the old version, please download latest version then open this project using My Visual Database.

Dmitry.

Re: Phone book database

Hello Dmitry,

I downloaded the latest version but still get the SQL INSERT syntax error because of an apostrophe in the last name to be added.

Post's attachments

Attachment icon Phonebook.jpg 24.08 kb, 12 downloads since 2017-04-19 

Re: Phone book database

Hello.


You are right, again the bug.


Please download latest beta version, fixed:
https://www.dropbox.com/s/4sb2tk75rauoj … b.zip?dl=0

Dmitry.