Helper Function not behaving the same when linked to different tables in an SQLite database

I am building an App, DUNA, that references and writes data to an sqlite database. One of the functions I have is to check if the UID from a table already exists. I do this for multiple tables with the following public helper function:

methods (Access = public)

    function results = checkUID(app,UID,table)
        conn = sqlite(app.database);  % This is defined as a Property
        if table == 'Deployment_Table'
            cat = 'Deployment_ID';
        elseif table == 'Logger_Table'
            cat = 'loggerUID';
        elseif table == 'Releaser_Table'
            cat = 'releaserUID';
        elseif table == 'Satellite_Table'
            cat = 'satUID';
        else
            cat = 'unitID';
        end

        sqlq = ['SELECT ' cat ' FROM ' table ' WHERE ' cat ' = "' UID '"'];

        results =fetch(conn, sqlq);
        close(conn)
        return

    end
end

In general, this works, it allows me to determine if the UID already exists across multiple tables.

I have created a panel, in which I've constructed a form for users to fill out with. There is a button function ('app.SubmitDataButtonPushed') at the bottom of the form, which accesses the data manually entered into the form and organizes it. For this post, it does two things: it generates a deployment ID that needs to be unique (e.g. not in the database) and it references the database to make sure we have records of each piece of equipment (e.g. it should be in the database). This is all done with the checkUID function above.

For the Deployment_ID check the function works as expected. The code is:

function SubmitDataButtonPushed(app, event)
            station = app.StationIDDropDown.Value;
            depDate = app.DeploymentDateDatePicker.Value;
            depDst= datetime(depDate, 'Format','yyyyMMdd');
            Deployment_ID = [station '_' char(depDst)];

            % Is this deployment already in the database?
            dbP =checkUID(app,Deployment_ID, 'Deployment_Table');

            if ~isempty(dbP) 
               uialert(fig, ['Error: Deployment ID ' Deployment_ID ' already exists.'], 'Database Error', "Icon","error");
            end
            ...  % More code here

Great. This works both when dbP is and is not empty. If it has data, it triggers the uialert, as intended. However, when I try to modify this code to see if the releaserUID is present, I get the following errors:

          ...  % Continue code here.
           % Releaser Check
           releaserTypes = app.ModelDropDown_2.Value  ;  %There are fixed values here.

           if releaserTypes == 'LRT (Sonardyne)'
              prefix='SD_';
           elseif releaserTypes == 'AR-60 (Sub Sea Sonic)'
              prefix = 'SSS_';
           elseif releaserTypes == 'R500 (Teledyne)'
              prefix = 'TD_';
           end

           releaserID = [prefix, char(app.ReleaseCodeEditField.Value)]; % Numbers taken from a user text edit field.

           dbR =checkUID(app,releaserID, 'Releaser_Table'); 

           if isempty(dbR) 
              uialert(fig, ['Error: releaser ID ' releaserID ' is not in database. Add information on releaser to database before adding deployment.'], 'Database Error', "Icon","error");
           end

This does not work. It gets hung on the dbR... line. When I run this, specifically stopping on the dbR line to make sure all of the variables are as they should be, I can see nothing out of place. The 'releaserID' variable is produce as a char string, as expected, and in my test runs, it matches an UID in the database. However, this is the error I get:

Arrays have incompatible sizes for this operation.

Error in DUNA/checkUID (line 101)
            if table == 'Deployment_Table'

Error in DUNA/SubmitDataButtonPushed (line 206)
            dbR =checkUID(app,releaserID, 'Releaser_Table');

Error in matlab.apps.AppBase>@(source,event)executeCallback(ams,app,callback,requiresEventData,event) (line 62)
            newCallback = @(source, event)executeCallback(ams, ...

Related documentation
 
Error while evaluating Button PrivateButtonPushedFcn.

I have tried this a bunch of different ways. Feeding different variables (LRT vs AR60, etc.). When I run the code manually in Matlab it works. Any ideas what is going on here? I just don't understand why it works with one set of data, and not another.

The table names for the database are correct.

Cheers!

Answer 1

[Emily T.]

For those of you that find this, the question was answered on Stack Exchange rather than this forum. The answer lies with the use of ' ' instead of " " in my function, which in the if loop matched character arrays letter by letter rather than the full string. I have since changed my function to not depend on if statements, but instead using switch/case (as I want to keep my variables characters for other reasons).

methods (Access = public)

function results = checkUID(app,UID,tableName)
conn = sqlite(app.database);
switch tableName
    case 'Deployment_Table'
        cat = 'Deployment_ID';
    case 'Logger_Table'
        cat = 'loggerUID';
    case 'Releaser_Table'
        cat = 'releaserUID';
    case 'Satellite_Table'
        cat = 'satUID';
end

sqlq = ['SELECT ' cat ' FROM ' tableName ' WHERE ' cat ' = "' UID '"'];
results =fetch(conn, sqlq);
close(conn)
return

end
end